Re: RI_ConstraintTrigger question

On 9/27/2005 3:27 PM, Tom Lane wrote:

> 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?

Dropping unnamed constraints can be a bit tedious.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #