Re: Trouble with Connection

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Robby Tanner <Robby(dot)Tanner(at)lightsource(dot)ca>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Trouble with Connection
Date: 2002-05-14 14:38:50
Message-ID: 25922.1021387130@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> Robby Tanner wrote:
>> I think the server engine is Postgres95.

> The current odbc driver doesn't support Postgres95.

I'm amazed there are still any running copies of Postgres95. Are you
holding it till the Smithsonian comes for it? :-)

Anyway, you should certainly not think in terms of using ODBC for an
upgrade. pg_dump, install new version, run pg_dump script is the thing
to do. Be advised that Postgres95 -> current is a large jump. There is
probably no hope that your dump script will load without manual editing.
(If the PG95 pg_dump supports dumping schema and data separately, I'd
advise doing it that way, since your editing will probably all be of
the schema declarations.)

regards, tom lane

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Francisco Jr. 2002-05-14 19:01:10 [ANN] Npgsql .Net Data Provider Launch at Gborg
Previous Message Margus 2002-05-14 14:07:44 Re: getting rid of CTIDs