[Pgcluster-general] replication work but CREATE FUNCTION not replicated
Jonathan
jonathan at exeko.com
Wed Nov 28 20:17:42 UTC 2007
Hello
can someone please help me ?
i am almost ok with my setup
just that Some fonction do not replicate to the second server
ERROR: unterminated dollar-quoted string at or near "$_$DECLARE
source ALIAS FOR $1;
destination ALIAS FOR $2;
command varchar" at character 104
STATEMENT: CREATE FUNCTION archive_table(source character varying, dest character varying) RETURNS boolean
AS $_$DECLARE
source ALIAS FOR $1;
destination ALIAS FOR $2;
command varchar
the create function is executed on the dbcluster where i run the query but not replicated on the second server
my 38G database is successfuly restored and replicated expect those small functions
the dump was created with pg_dumpall from our current postgres install
thank you for your help
Jonathan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20071128/f7155339/attachment.html
More information about the Pgcluster-general
mailing list