Marc G. Fournier wrote: > > > On Mon, 27 Oct 2003, Bruce Momjian wrote: > > > Changes > > ------- > > Allow superuser (dba?) the ability to turn off foreign key checks/all > > constraints/triggers, not settable from postgresql.conf? > > feature, not bug fix, no?
It became important when everyone realized that 7.4 would be first major upgrade with full foreign key checking --- prior to that we did CREATE CONSTRAINT TRIGGER that didn't check data. Basically, that's how it got on the open item list. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match