Re: [GENERAL] [SQL] Problem: Referential Integrity Constraints lost

2002-11-07 Thread Achilleus Mantzios
On Thu, 7 Nov 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > After recreating the missing triggers should i upgrade > > to 7.2.3?? > > Make that "before". > > I frankly suspect pilot error here. Triggers do not simply disappear. > If you did have crash-induced corrupti

Re: [GENERAL] [SQL] Problem: Referential Integrity Constraints lost

2002-11-07 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > After recreating the missing triggers should i upgrade > to 7.2.3?? Make that "before". I frankly suspect pilot error here. Triggers do not simply disappear. If you did have crash-induced corruption leading to loss of some rows in pg_trigger, it w