Re: [GENERAL] RI_ConstraintTrigger question

2005-09-28 Thread Florian G. Pflug
[EMAIL PROTECTED] wrote: Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: On 9/27/2005 12:20 AM, George Essig wrote: We have a database with about 30 tables and some RI. The RI constraints, however, were not named upon creation of the database 2-3 years ago and now when we get an

Re: [GENERAL] RI_ConstraintTrigger question

2005-09-27 Thread [EMAIL PROTECTED]
Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: On 9/27/2005 12:20 AM, George Essig wrote: We have a database with about 30 tables and some RI. The RI constraints, however, were not named upon creation of the database 2-3 years ago and now when we get an error it contains for the constra

Re: [GENERAL] RI_ConstraintTrigger question

2005-09-27 Thread Jan Wieck
On 9/27/2005 3:27 PM, Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: On 9/27/2005 12:20 AM, George Essig wrote: We have a database with about 30 tables and some RI. The RI constraints, however, were not named upon creation of the database 2-3 years ago and now when we get an error it co

Re: [GENERAL] RI_ConstraintTrigger question

2005-09-27 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > On 9/27/2005 12:20 AM, George Essig wrote: >>> We have a database with about 30 tables and some RI. The RI constraints, >>> however, were not named upon creation of the database 2-3 years ago and >>> now when we get an error it contains for the constraint.

Re: [GENERAL] RI_ConstraintTrigger question

2005-09-27 Thread Jan Wieck
On 9/27/2005 12:20 AM, George Essig wrote: On 9/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wro We have a database with about 30 tables and some RI. The RI constraints, however, were not named upon creation of the database 2-3 years ago and now when we get an error it contains for the constr

Re: [GENERAL] RI_ConstraintTrigger question

2005-09-26 Thread George Essig
On 9/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wro We have a database with about 30 tables and some RI. The RI constraints,however, were not named upon creation of the database 2-3 years ago andnow when we get an error it contains for the constraint. I tried Google and the documentation, and I

[GENERAL] RI_ConstraintTrigger question

2005-09-26 Thread [EMAIL PROTECTED]
We have a database with about 30 tables and some RI. The RI constraints, however, were not named upon creation of the database 2-3 years ago and now when we get an error it contains for the constraint. I tried Google and the documentation, and I still have 2 questions - 1. Is it possible to r