Re: default to WITHOUT OIDS? Possible related problem - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: default to WITHOUT OIDS? Possible related problem
Date
Msg-id 200301260216.h0Q2GpA24295@candle.pha.pa.us
Whole thread Raw
In response to Re: default to WITHOUT OIDS? Possible related problem  (Emmanuel Charpentier <charpent@bacbuc.dyndns.org>)
List pgsql-hackers
Emmanuel Charpentier wrote:
> Tom Lane wrote:
> > Daniel Kalchev <daniel@digsys.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 ?

Yes.  We think we may have a fix in 7.3.2.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: What goes into the security doc?
Next
From: Lamar Owen
Date:
Subject: Re: Can we revisit the thought of PostgreSQL 7.2.4?