On Fri, Feb 17, 2012 at 02:30:24PM +0000, Shaun McCloud wrote: > My code is not creating the dump with --disable-triggers.
There are very few things it could be then. If it works in other situations, that means the Slony triggers are enabled and working on the tables, which rules out one possibility. Open the pg_dump output in a text editor and make sure it is using INSERTs, and that there is nothing funny at the top of the script (e.g. changing the session_replication_role or disabling triggers). Also, I'm assuming this is a --data-only pg_dump? Finally, make sure your are loading the output into the correct database and that no search_path/schema tweaks could be affecting things. If all else fails, see if you can create a simple test case (e.g. pg_dump a single small table) and post it here. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
pgpeY9bINxrs2.pgp
Description: PGP signature
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
