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