<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>I recommend you install this function in template1 database, to avoid this problem in the future.<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;">
<link href="/zimbra/css/msgview.css?v=110928141302" rel="stylesheet">
<br>
You were right, Lazaro. It should have been installed in all
databases, but it wasn't.<br>
Now it works fine.<br>
<br>
Many thanks.<br>
<br>
El 03/05/12 19:00, Lazaro Ruben Garcia Martinez escribió:
<blockquote cite="mid:ef96dd89-f30c-47be-9b9d-d7a32a380cc0@ucimail3.uci.cu">
<style>p { margin: 0; }</style>
<div style="font-family: Times New Roman; font-size: 14pt; color:
#000000">It seems to me that pgpool_regclass function is not
installed in the database where pgpool connects. Is the function
installed in all databases?<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>
Yes, it's installed in both servers. The version is
pgpool-II-3.1.2.<br>
<br>
Regards.<br>
<br>
El 03/05/12 17:50, Lazaro Ruben Garcia Martinez escribió:
<blockquote cite="mid:56619eb5-ea68-4814-8727-14d4559e6714@ucimail3.uci.cu">
<style>p { margin: 0; }</style>
<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>
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE
LAS CIENCIAS INFORMATICAS...<br>
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.uci.cu" target="_blank">http://www.uci.cu</a><br>
<a class="moz-txt-link-freetext" href="http://www.facebook.com/universidad.uci" target="_blank">http://www.facebook.com/universidad.uci</a><br>
<a class="moz-txt-link-freetext" href="http://www.flickr.com/photos/universidad_uci" target="_blank">http://www.flickr.com/photos/universidad_uci</a><br>
</blockquote>
<br>
</div>
<br>
<a href="http://www.uci.cu/" target="_blank"> <img src="http://universidad.uci.cu/email.gif" src="http://universidad.uci.cu/email.gif"> <br>
</a></blockquote>
<br>
<a href="http://www.uci.cu/" target="_blank">
<img src="http://universidad.uci.cu/email.gif" src="http://universidad.uci.cu/email.gif">
<br>
</a></blockquote>
<br>
</div>
<br>
<a href="http://www.uci.cu/" target="_blank">
<img src="http://universidad.uci.cu/email.gif" src="http://universidad.uci.cu/email.gif">
<br>
</a></blockquote>
<br>
<a href="http://www.uci.cu/" target="_blank">
<img src="http://universidad.uci.cu/email.gif" src="http://universidad.uci.cu/email.gif">
<br>
</a></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>