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 #