On 9/27/2005 3:27 PM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> 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. #
#================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
