Re: [SL] 2.6.22 -> 2.8.15 upgrade error

[Stuart L. <sl...@cc...>]

On 日, 2008-06-22 at 13:50 +0200, Rolf Stöckli wrote:
> It seems your database already contains a table "cargo". You should find 
> it somewhere in your dump file.
> 1) Make a backup.
> 2) Insert at the beginning of sql/Pg-upgrade-2.7.0-2.7.5.sql:
> 
> drop table if exists cargo;
> 
> 3) Try again to upgrade.
> 
> Stuart Luppescu schrieb:
> > Error!
> > create table cargo (id int not null, trans_id int not null, package
> > text, netweight float4, grossweight float4, volume float4)
> > ERROR: relation "cargo" already exists

Rolf, I entered that line, but got this error:

Error!
drop table if exists cargo
ERROR: syntax error at or near "exists" at character 15

Right after that is the line that creates the cargo relation. Perhaps I
should try and comment out that line...

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
<gholam> well I'm impressed <gholam> win98 managed
 to crash X from within vmware. * gholam applauds.