<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>The pgpool_regclass function is installed in all servers?. What version of pgpool-II are you using?<br><br>Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><br> Hi,<br><br> I have pgpool running with two postgres servers in master/slave <br>mode with streaming replication.<br> But now I have started to use it and some errors have appeared in <br>the slave postgres log. They look related to pgpool since they involve <br>pgpool_regclass function.<br><br>28949 2012-05-03 14:25:06 CEST ERROR: function pgpool_regclass(unknown) <br>does no<br>t exist at character 69<br>28949 2012-05-03 14:25:06 CEST HINT: No function matches the given name <br>and argument types. You might need to add explicit type casts.<br>28949 2012-05-03 14:25:06 CEST STATEMENT: SELECT count(*) FROM pg_class <br>AS c, p<br>g_namespace AS n WHERE c.oid = pgpool_regclass('pg_namespace') AND <br>c.relnamespac<br>e = n.oid AND n.nspname = 'pg_catalog'<br>28949 2012-05-03 14:25:06 CEST ERROR: function pgpool_regclass(unknown) <br>does no<br>t exist at character 61<br>28949 2012-05-03 14:25:06 CEST HINT: No function matches the given name <br>and argument types. You might need to add explicit type casts.<br>28949 2012-05-03 14:25:06 CEST STATEMENT: SELECT count(*) FROM <br>pg_catalog.pg_cl<br>ass AS c WHERE c.oid = pgpool_regclass('Diccionario') AND <br>c.relpersistence = 'u'<br><br> Diccionario is one of our tables, so I initially thought it could <br>be a bug of our application, but since pg_namespace is an internal one, <br>I turn to the function itself. It looks like it's expecting an argument <br>of a type, but other one is passed to.<br><br> The errors happened also on the master server when the slave was <br>down for testing, but when it was recovered to the cluster, errors <br>stopped in the server and started in the slave.<br><br> I don't know if it's a bug or if the error is not important. I'd <br>really appreciate if someone could offer an answer to any of these <br>questions.<br><br> Many thanks.<br><br><br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>