Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> The correct use of dependency information would be to sort the DROPs > >> into an order that should succeed *without* CASCADE. (This will > >> actually happen for free AIUI, once pg_dump uses dependency info fully. > >> DROPping in the reverse of a safe creation order should work.) > > > Right, but how do you drop two tables that REFERENCE each other? Seems > > you have to use CASCADE in that case. > > Nope. It's still the inverse problem of pg_dump. pg_dump would have to > dump such a construction with CREATE TABLEs followed by ALTER TABLE ADD > FOREIGN KEYs, right? So the DROPs issued in reverse order are ALTER > TABLE DROP CONSTRAINTs followed by DROP TABLE.
Yep. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
