Thread: restoring 7.2 data to 7.3dev
i did a pg_dumpall in 7.2, and tried to load that file back into 7.3 snap from today and got many errors. some tables even failed to load. also, in one of my script, LIMIT X,X worked in 7.2, now it gave an error about using LIMIT and OFFSET. did something change there?
On Fri, Feb 22, 2002 at 02:43:31AM -0600, Thomas T. Thai wrote: > i did a pg_dumpall in 7.2, and tried to load that file back into 7.3 snap > from today and got many errors. some tables even failed to load. also, in > one of my script, LIMIT X,X worked in 7.2, now it gave an error about > using LIMIT and OFFSET. did something change there? Dunno about the first problem but the LIMIT code did indeed change. IIRC the LIMIT X,Y is non-standard and postgres happened to to have the meaning switched around compared to other databases (by accident). So rather than supporting the ambiguous and incompatably implemented LIMIT X,Y stuff it was ripped out and people told to use the unambiguous LIMIT/OFFSET instead. Something like that anyway. The archive should have more details. HTH, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > If the company that invents a cure for AIDS is expected to make their > money back in 17 years, why can't we ask the same of the company that > markets big-titted lip-syncing chicks and goddamn cartoon mice?
Thomas T. Thai wrote: > i did a pg_dumpall in 7.2, and tried to load that file back into 7.3 snap > from today and got many errors. some tables even failed to load. also, in > one of my script, LIMIT X,X worked in 7.2, now it gave an error about > using LIMIT and OFFSET. did something change there? Yes, LIMIT #,# will be removed in 7.3, as mentioned in the release notes. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Fri, 22 Feb 2002, Bruce Momjian wrote: > Thomas T. Thai wrote: > > i did a pg_dumpall in 7.2, and tried to load that file back into 7.3 snap > > from today and got many errors. some tables even failed to load. also, in > > one of my script, LIMIT X,X worked in 7.2, now it gave an error about > > using LIMIT and OFFSET. did something change there? > > Yes, LIMIT #,# will be removed in 7.3, as mentioned in the release > notes. relating to this upgrade, i started using tsearch in contrib, and it uses it's own datatype. i did a pg_dumpall in 7.2 and tried to load the dump back into 7.3 and noticed that datatypes aren't save properly. i don't think this is a 7.x issue, but a pg_dumpall issue. how would i go about getting those datatypes back during the restore or how to save it so i can restore it back?