Re: [HACKERS] default to WITHOUT OIDS? Possible related problem

2003-01-25 Thread Bruce Momjian
Emmanuel Charpentier wrote:
 Tom Lane wrote:
  Daniel Kalchev [EMAIL PROTECTED] 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
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] default to WITHOUT OIDS? Possible related problem

2003-01-19 Thread Emmanuel Charpentier
Tom Lane wrote:

Daniel Kalchev [EMAIL PROTECTED] 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



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html