Jan Wieck <JanWieck@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
