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/
Show quoted text
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 19026On 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?