From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Wes Williams <wes_williams(at)fcbonline(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Upgrading from 8.0 to 8.1 (w32) |
Date: | 2005-11-07 22:56:54 |
Message-ID: | 1131404214.11333.80.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, 2005-11-07 at 16:24 -0500, Wes Williams wrote:
> Before axing the 8.0 installation I used "backup" from pgAdmin III (v1.4
> w32) of my database to restore into the fresh install of 8.1
>
> Since this is my first backup test, the data is not critical, but I would
> like to be able to use the backup. However, after creating the new database
> in 8.1 and trying to load my SQL query from the backup, I get an error
> message: "ERROR: syntax error at or near "0" at character 8664"
>
> The worst part is that I don't know where character 8664 is as the SQL
> editor window counts in lines, columns, and rows...no character place
> indicator. 8(
>
> Does anyone have any suggestions on how to find the character 8664 or how
> else to load my backup .sql into Postgre 8.1?
Use psql:
psql -d mydatabase -f /path/to/backup/file
When you use -f, you can see line numbers.
one possibility is that you will find the error in a function body, that
was accepted without checking by earlier versions but is now being
checked by 8.1.
Oliver Elphick
From | Date | Subject | |
---|---|---|---|
Next Message | Wes Williams | 2005-11-08 12:45:09 | Re: Upgrading from 8.0 to 8.1 (w32) |
Previous Message | Wes Williams | 2005-11-07 21:24:19 | Upgrading from 8.0 to 8.1 (w32) |