On Tue, Jun 15, 2010 at 08:58:52AM -0600, Peter Lee wrote: > I am trying to upgrade our postgresql from 8.3 to 8.4. > > I found the "window" as field name makes many errors during > pg_restore. > > - like "item.window". > > Is there any way I can restore the dump file from 8.3 without > errors.
Use 8.4's pg_dump on the running 8.3 database, and your problem will be fixed :) Cheers, David (oh, and pg_dump -Fc will let pg_restore, an enormously powerful utility, do its magic). -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
