Re: default to WITHOUT OIDS? Possible related problem

From: Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: default to WITHOUT OIDS? Possible related problem
Date: 2003-01-20 06:13:00
Message-ID: b0g41c$8om$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Daniel Kalchev <daniel(at)digsys(dot)bg> writes:
>
>>If ever this happens, same should be considered for tables created via the
>>SELECT INTO statement. These are in many cases 'temporary' in nature and do
>>not need OIDs (while making much use of the OIDs counter).
>
>
> SELECT INTO does create tables without OIDs, as of 7.3. We've already
> had complaints about that ;-)

I very recently updated one of my servers to 7.3.1. Various MS tools have
started to give me guff when trying to access views in databases on that
server through ODBC. Especially, MS Query (yes, I have some Excel users
needing that) started complaining that "this table has no OID", which
really means that the ODBC driver complaints that ...

Is that a side effect of the above problem ?

Sincerely,

Emmanuel Charpentier

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Kalchev 2003-01-20 09:31:56 Re: Options for growth
Previous Message Bruno Wolff III 2003-01-20 06:09:09 Re: Getting float8 data into cube?