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

[Vladimir Klejch]

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
-------------- next part --------------
_______________________________________________
Pgcluster-general mailing list
Pgcluster-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgcluster-general