From: | "Wes Williams" <wes_williams(at)fcbonline(dot)net> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Upgrading from 8.0 to 8.1 (w32) |
Date: | 2005-11-08 12:45:09 |
Message-ID: | 000b01c5e462$418ffad0$326400bd@fcb.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for your tip Oliver, I'll certainly use it next time.
I was able to import the backup late last night by dismantling it and
loading in sections. It was then I noticed the subtle coloring differences
in pgAdmin III indicating the errors. Indeed, all of the functions were
causing errors so I simply removed them. The primary error stopping my data
from loading was due to a good old Irish name, "O'Sali", in my database.
The "'" threw off the SQL COPY command apparently.
Suggestions for improvement to pgAdmin III:
As an aside, it would be GREAT if pgAdmin highlighted [like a yellow
background] the errors to make them more visible in addition to searching
for errors or finding the character number.
======
Keep up the good work, pgAdmin III v1.4 is easier for us novices to learn
with and the tips are very helpful.
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Oliver Elphick
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Wes Williams | 2005-11-08 12:58:46 | Re: Upgrading from 8.0 to 8.1 (w32) |
Previous Message | Oliver Elphick | 2005-11-07 22:56:54 | Re: Upgrading from 8.0 to 8.1 (w32) |