Martijn van Oosterhout wrote: -- Start of PGP signed section. > On Wed, Sep 28, 2005 at 10:41:12PM -0400, Bruce Momjian wrote: > > > > Also, why is the nextval ::text casting output by pg_dump anyway? > > AFAICS, pg_dump outputs "serial" (at least in 7.4.7 which is what I > have to hand) when it should meaning that dumps restored will get the > new syntax anyway. Or am I missing something? > > Isn't this what adddepend was for? I can beleive there are version > dependancies here...
Right, we think we can get SERIAL to work fine. It is manual use of nextval() in DEFAULT that we are worried about, and there is probably not too much use of that. There is no dependency info about that. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (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 6: explain analyze is your friend
