Re: RI_ConstraintTrigger question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: George Essig <george(dot)essig(at)gmail(dot)com>, "pobox(at)verysmall(dot)org" <pobox(at)verysmall(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: RI_ConstraintTrigger question
Date: 2005-09-27 19:27:11
Message-ID: 9771.1127849231@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jan Wieck <JanWieck(at)Yahoo(dot)com> 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 <unnamed> for the constraint.

> What you could do is to dump the database, edit the dump and restore it.

Why not just drop and re-add the FK constraints?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2005-09-27 19:34:46 Re: RI_ConstraintTrigger question
Previous Message Jan Wieck 2005-09-27 19:04:39 Re: RI_ConstraintTrigger question