| From: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: restoring 7.2 data to 7.3dev |
| Date: | 2002-02-22 16:17:37 |
| Message-ID: | Pine.NEB.4.43.0202221014360.16819-100000@ns01.minnesota.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | david blood | 2002-02-22 16:41:54 | vacuum analyze never finishes |
| Previous Message | Lincoln Yeoh | 2002-02-22 15:47:14 | Re: Protection of intellectual property (Schema & SQL code) |