From: | Maarten Boekhold <maartenb(at)dutepp2(dot)et(dot)tudelft(dot)nl> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | Andrew Martin <martin(at)biochemistry(dot)ucl(dot)ac(dot)uk>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] How to...? |
Date: | 1998-03-09 15:47:10 |
Message-ID: | Pine.SUN.3.91.980309164636.21544C-100000@dutepp2.et.tudelft.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 9 Mar 1998, The Hermit Hacker wrote:
> On Mon, 9 Mar 1998, Andrew Martin wrote:
>
> > > Then, using what was left, I did:
> > >
> > > psql -e < db.dump
> > >
> > > Again. Failed misearbly, with the following coming from the 'copy
> > > to <relname> from stdin;' section:
> > >
> > > 344984 johnb xgSldZdYEgIWo clio.trends.ca n \N
> >
> > I got something kind-of similar with a core dump... This was 'cos of a
> > column name which is now a reserved word.
>
> Ack, I fear you are correct...the third field above is 'password',
> which became a reserved word in v6.3...oh man, is this upgrade ever going
> to hurt...my 'db.dump' file is 84Meg...vi just loves it :)
How about starting up your old pgsql, then psql, the 'alter table rename
column.....'
Maarten
_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Aycock/IntelliQuest | 1998-03-09 16:15:05 | Re: [HACKERS] Re: [QUESTIONS] Testing Postgresql v6.3 |
Previous Message | Maurice Gittens | 1998-03-09 15:36:07 | Re: [HACKERS] newoid in invapi.c |