Re: Upgrading from 8.0 to 8.1 (w32)

Another interesting tidbit.

Executing the same SQL backup file in pgAdmin III SQL query window failed
and returns an error based on some line number (after removing the
previously indicated errors).

Interestingly, using the suggested from the CLI:

psql -d mydatabase -f /path/to/backup/file

and the backup loaded just fine. Then I emptied the database and tried the
original backup, functions and all. In this instance the command line
returned some errors/warnings but still proceeded to load my data. 8)

Thanks again Oliver!

-----Original Message-----
From: Oliver Elphick [mailto:olly(at)lfix(dot)co(dot)uk]
Sent: Monday, November 07, 2005 5:57 PM
To: Wes Williams
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] 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