Re: RI_ConstraintTrigger question

Jan Wieck <JanWieck@Yahoo.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