Sun Apr 6 16:44:22 PDT 2008
- Previous message: [Slony1-general] Re: ERROR: XX000: cache lookup failed for relation
- Next message: [Slony1-general] ERROR: Slony-I: old key column TTT.FFF IS NULL on {UPDATE, DELETE}
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All,
We have recently experienced an incident whereby certain tables were
directly updated and new columns and constraints added without using the
execute script function. We are now receiving errors (ERROR: Slony-I: old
key column TTT.FFF IS NULL on {UPDATE,DELETE}) on certain transactions, and
these transactions are being rolled back. The DDL changes were also done on
the slave node, so schemas are are both correct. I believe the issue is to
do with the triggers not being updated after .
What is the best way to update/rebuild the existing triggers on tables which
have been modified ?
Thanks
James
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080407/=
1b34775e/attachment.htm
- Previous message: [Slony1-general] Re: ERROR: XX000: cache lookup failed for relation
- Next message: [Slony1-general] ERROR: Slony-I: old key column TTT.FFF IS NULL on {UPDATE, DELETE}
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list