Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-05 Thread Marco Colombo
On Mon, 4 Oct 2004, Tom Lane wrote: "Jimmie H. Apsey" <[EMAIL PROTECTED]> writes: I'd recommend an upgrade to 7.4.5 at your earliest convenience. I have kept up-to-date our Red Hat kernels as you can probably see from the Linux 2.4.9-e.49smp kernel. Am I required to maintain my own version of Post

Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Tom Lane
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes: >> I'd recommend an upgrade to 7.4.5 at your earliest convenience. >> > I have kept up-to-date our Red Hat kernels as you can probably see from > the Linux 2.4.9-e.49smp kernel. Am I required to maintain my own > version of Postgres alongside and co

Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Martijn van Oosterhout
On Mon, Oct 04, 2004 at 05:25:59PM -0400, Jimmie H. Apsey wrote: > I have kept up-to-date our Red Hat kernels as you can probably see from > the Linux 2.4.9-e.49smp kernel. Am I required to maintain my own > version of Postgres alongside and compiled into Red Hat's latest and > greatest kernel?

Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Jimmie H. Apsey
Tom Lane wrote: "Jimmie H. Apsey" <[EMAIL PROTECTED]> writes: Each FK constraint should have three associated triggers (two on the referencing table, one on the referenced table). OH, that's very scary for me that triggers can vanish/be eliminated

Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Tom Lane
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes: >> Each FK constraint should have three associated triggers (two on the >> referencing table, one on the referenced table). > OH, that's very scary for me that triggers can vanish/be eliminated w/o > my direct action. Yes, I do now see that the trigg

Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Jimmie H. Apsey
Tom Lane wrote: "Jimmie H. Apsey" <[EMAIL PROTECTED]> writes: Referential Integrity on one of our production tables seems to have been lost. I am running Postgres 7.1.3 embedded within Red Hat kernel-2.4.9-e.49. 7.1 is mighty ancient, but ... I do not know

Re: [GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Tom Lane
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes: > Referential Integrity on one of our production tables seems to have been > lost. I am running Postgres 7.1.3 embedded within Red Hat > kernel-2.4.9-e.49. 7.1 is mighty ancient, but ... > I do not know how to disable referential integrity on a col

[GENERAL] LOST REFERENTIAL INTEGRITY

2004-10-04 Thread Jimmie H. Apsey
Referential Integrity on one of our production tables seems to have been lost. I am running Postgres 7.1.3 embedded within Red Hat kernel-2.4.9-e.49. Within that I have a table with referential integrity constraints which no longer work. I do not know how to disable referential integrity on a