Re: [SQL] Without OIDs

2006-03-02 Thread Michael Fuhr
On Thu, Mar 02, 2006 at 05:14:54AM -0800, Emil Rachovsky wrote: > I'm creating a temporary table in a function and using > Alter Table ... Without OIDs, but when the function is Why alter the table? Why not specify WITHOUT OIDS when you create the table? > called for the second time I get an err

[SQL] Without OIDs

2006-03-02 Thread Emil Rachovsky
Hello, I'm creating a temporary table in a function and using Alter Table ... Without OIDs, but when the function is called for the second time I get an error "relation with OIDs ... doesn't exist" on an insert statement to the table. I'm using Postgre 8.0 which says that supports without OIDs. An

Re: [SQL] WITHOUT OIDS by default

2003-11-16 Thread Bruce Momjian
ow wrote: > Hi, > > Is there a way to specify that all tables should be created WITHOUT OIDS by > default? No, and strangely it wasn't on the TODO list. I just added it: * Add GUC setting to make created tables default to WITHOUT OIDS -- Bruce Momjian| http:

[SQL] WITHOUT OIDS by default

2003-11-16 Thread ow
Hi, Is there a way to specify that all tables should be created WITHOUT OIDS by default? Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ---(end of broadcast)-