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

2002-11-08 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 corruption leading to

Re: [HACKERS] [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 would