Thread: Re: [GENERAL] Drop column and Access

Adrian Klaver <aklaver@attbi.com> writes:
> Programs used -Postgres 7.3,SuSE 7.2,psqlODBC 7.02.00.04,Access95,97,Win95,98.
> I have a Postgres database running on a Linux server. I dropped a column on
> one of the tables. When I tried to relink the table in Access it complained
> it couldn't find the table because of a naming violation.

Sounds like psqlODBC may not yet know it's supposed to ignore pg_attribute
entries with attisdropped true.

            regards, tom lane

Tom Lane wrote:
>
> Adrian Klaver <aklaver@attbi.com> writes:
> > Programs used -Postgres 7.3,SuSE 7.2,psqlODBC
> > 7.02.00.04,Access95,97,Win95,98.
> > I have a Postgres database running on a Linux server.
> > I dropped a column on one of the tables. When I tried
> > to relink the table in Access it complained
> > it couldn't find the table because of a naming violation.
>
> Sounds like psqlODBC may not yet know it's supposed to
> ignore pg_attribute entries with attisdropped true.

Hmm isn't it your responsibility to change the code ?
It was you who rejected all the proposals which don't
need the attisdropped test.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Tom Lane wrote:
>> Sounds like psqlODBC may not yet know it's supposed to
>> ignore pg_attribute entries with attisdropped true.

> Hmm isn't it your responsibility to change the code ?

Well, perhaps so, but I have no ability to test ODBC, and it's not
even in the PG CVS tree anymore, so I have no ability to make the
change anyway.

            regards, tom lane