I found the problem. The CREATE TABLE statements from the 
Postgre95 dump had "archive = none" at the end, right before
the semicolon. Once I took these out to fix those errors, 
the import went smoothly.

So, out of curiosity, what is the "archive = none" all about
and why is it no longer valid?

On Thu, Jul 12, 2001 at 01:00:27PM -0400, [EMAIL PROTECTED] wrote:
> Is it possible to import a dump from Postgresql95
> into Postgres 7.x? I get plenty of errors from the
> old dumpfile, so I assume there is a trick to it
> or it can not be done directly. If you could give
> me a quick point in the right direction I will be
> your best friend :)
> 
> Later,
> -- 
> \ Craig "Cowboy" McDaniel 
> /_\ Software Engineer
> /_/_\ Internet Tool & Die
> /_/_/_\ [EMAIL PROTECTED]
> /_/_/_/_\ (502) 584-8665 ext 108
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

-- 
\ Craig "Cowboy" McDaniel 
/_\ Software Engineer
/_/_\ Internet Tool & Die
/_/_/_\ [EMAIL PROTECTED]
/_/_/_/_\ (502) 584-8665 ext 108

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to