[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