[pgpool-general: 416] Re: pgpool_regclass error

[Juan Jose Perez]

     You were right, Lazaro. It should have been installed in all 
databases, but it wasn't.
     Now it works fine.

     Many thanks.

El 03/05/12 19:00, Lazaro Ruben Garcia Martinez escribió:
> It seems to me that pgpool_regclass function is not installed in the 
> database where pgpool connects. Is the function installed in all 
> databases?
>
> Regards.
>
> ------------------------------------------------------------------------
>
>
>         Yes, it's installed in both servers. The version is
>     pgpool-II-3.1.2.
>
>         Regards.
>
>     El 03/05/12 17:50, Lazaro Ruben Garcia Martinez escribió:
>
>         The pgpool_regclass function is installed in all servers?.
>         What version of pgpool-II are you using?
>
>         Regards.
>
>         ------------------------------------------------------------------------
>
>
>                  Hi,
>
>                  I have pgpool running with two postgres servers in
>             master/slave
>             mode with streaming replication.
>                  But now I have started to use it and some errors have
>             appeared in
>             the slave postgres log. They look related to pgpool since
>             they involve
>             pgpool_regclass function.
>
>             28949 2012-05-03 14:25:06 CEST ERROR:  function
>             pgpool_regclass(unknown)
>             does no
>             t exist at character 69
>             28949 2012-05-03 14:25:06 CEST HINT:  No function matches
>             the given name
>             and argument types. You might need to add explicit type casts.
>             28949 2012-05-03 14:25:06 CEST STATEMENT:  SELECT count(*)
>             FROM pg_class
>             AS c, p
>             g_namespace AS n WHERE c.oid =
>             pgpool_regclass('pg_namespace') AND
>             c.relnamespac
>             e = n.oid AND n.nspname = 'pg_catalog'
>             28949 2012-05-03 14:25:06 CEST ERROR:  function
>             pgpool_regclass(unknown)
>             does no
>             t exist at character 61
>             28949 2012-05-03 14:25:06 CEST HINT:  No function matches
>             the given name
>             and argument types. You might need to add explicit type casts.
>             28949 2012-05-03 14:25:06 CEST STATEMENT:  SELECT count(*)
>             FROM
>             pg_catalog.pg_cl
>             ass AS c WHERE c.oid = pgpool_regclass('Diccionario') AND
>             c.relpersistence = 'u'
>
>                  Diccionario is one of our tables, so I initially
>             thought it could
>             be a bug of our application, but since pg_namespace is an
>             internal one,
>             I turn to the function itself. It looks like it's
>             expecting an argument
>             of a type, but other one is passed to.
>
>                  The errors happened also on the master server when
>             the slave was
>             down for testing, but when it was recovered to the
>             cluster, errors
>             stopped in the server and started in the slave.
>
>                  I don't know if it's a bug or if the error is not
>             important. I'd
>             really appreciate if someone could offer an answer to any
>             of these
>             questions.
>
>                  Many thanks.
>
>
>             _______________________________________________
>             pgpool-general mailing list
>             pgpool-general at pgpool.net
>             http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>             10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS
>             CIENCIAS INFORMATICAS...
>             CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
>
>             http://www.uci.cu
>             http://www.facebook.com/universidad.uci
>             http://www.flickr.com/photos/universidad_uci
>
>
>
>
>         <http://www.uci.cu/>
>
>
>
>     <http://www.uci.cu/>
>
>
>
>
> <http://www.uci.cu/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120507/1f00901a/attachment.html>