On Dec 10, 2007 1:50 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote: > Peter Koczan escribió: > > Hi all, > > > > I am having a problem with what appear to be legacy foreign keys in > > some of my databases (probably pre-7.2 days). They won't restore from > > 8.2 to 8.3, because the '<unnamed>' field in the called function isn't > > unique when I try to restore more than one of these legacy keys > > 8.3's pg_dump contains smarts to dump these things as normal FKs. Try > it. Oh, that explains the problems...I was using 8.2's pg_dump. I'll try it out. Thanks. Peter ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend