logo       
Google Custom Search
    AddThis Social Bookmark Button

replication work but CREATE FUNCTION not replicated: msg#00018

Subject: replication work but CREATE FUNCTION not replicated
This is a multi-part message in MIME format.
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


Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>