[Bucardo-general] Patch to Fix Pg_class Trigger Disable/Enable & Reserved Word Table Names Problem

Ben Allen bsa at lanl.gov
Tue Mar 24 04:34:36 UTC 2009


Looks like it works fine. Thanks, Ben.

On Mar 23, 2009, at 3:47 PM, Greg Sabino Mullane wrote:

> Ben Allen wrote:
>> In PostgreSQL 8.2, with pg_class trigger disabling/enabling and table
>> names that are reserved words like set and sequence, there is a bug  
>> that
>> the SQL executed doesn't actually disable/enable triggers.
>
> Yikes, thanks for spotting that. I ended up calling quote_literal in  
> addition to
> quote_ident in the checktable section. Please make sure it works for  
> you, I've
> not tested it yet. Just pushed as 9f2bd5df.
>
> -- 
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8




More information about the Bucardo-general mailing list