On Tue, 22 Feb 2000 sszabo@bigpanda.com wrote:
> * pg_dump will dump CREATE CONSTRAINT TRIGGER statements for
> tables with foreign key constraints. In data only dumps,
> pg_dump does a little bit of magic with the system catalogs
> to turn off all triggers on user defined tables and turn
> them back on at the end.
Whatever happened to the idea of a SET command for this? IIRC, SQL already
has a contraint related set command (for deferring, etc.). Why not
overload that to turn off foreign keys? I could imagine that being useful
for people developing database schemas.
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden