Re: Upgrading from 8.0 to 8.1 (w32)

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