Re: [HACKERS] How to...?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Maarten Boekhold <maartenb(at)dutepp2(dot)et(dot)tudelft(dot)nl>
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 16:52:28
Message-ID: Pine.NEB.3.95.980309115157.23315K-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 9 Mar 1998, Maarten Boekhold wrote:

> 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.....'

Cause I keep forgetting that I can do that :( Point taken and
will try that out, thanks...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-03-09 17:11:37 Re: [HACKERS] How to...?
Previous Message Bruce Momjian 1998-03-09 16:39:57 Re: [HACKERS] Re: [QUESTIONS] Testing Postgresql v6.3