[Pgcluster-general] replication work but CREATE FUNCTION not replicated

[Jonathan]

Wow thanks for the very fast answer :)
i will check this as soon as i wake up tomorrow morning
i am sure this can help.

Jonathan
----- Original Message ----- 
From: "Vladimir Klejch" <klejch+pgcluster at netbox.cz>
To: <pgcluster-general at pgfoundry.org>
Sent: Thursday, November 29, 2007 12:16 AM
Subject: Re: [Pgcluster-general] replication work but CREATE FUNCTION not 
replicated


>
> Hi
>
> i found this as a bug in pgcluster  long time ago and discussed about
> on list and solved this by small patch , but this patch isn't in a
> mainstream pgcluster. see
> http://lists.pgfoundry.org/pipermail/pgcluster-general/2006-May/000718.html
>
> I hope, this help
>
>
>  Kleo
>
>
> On Wed, 28 Nov 2007, Jonathan wrote:
>
>> 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
>
> -- 
>
> Vladimír 'Kleo' Klejch


--------------------------------------------------------------------------------


> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>


--------------------------------------------------------------------------------


> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>