Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group