RE: temp tables and serial columns

That is what I did, obnixio, except the column is int in the temp.And one table looks like this:create temp table v ( vendor_id integer not null , ---- this is SERIAL in the master file ... vendor_no char(15) not null ,-- 75 more columns go here ....................................... ) with no log;and there was another of similar size.This is no big deal.But it would not take an ibm/informix developer very long to eliminate the serial inheritance crap from a tempor provide an option.This is just a pet bitch of mine when I run into it now and then.I just wanted to know if someone found a 'back door' way to make it work the way it "should".> Date: Fri, 9 Mar 2007 20:12:36 +0000> Subject: RE: temp tables and serial columns> From: obnoxio@serendipita.com> To: garage_dba@hotmail.com> CC: informix-list@iiug.org> > Bill Hamilton said:> > That would be nice.Or just allow something like:"select * from foo into> > temp t serialasint;"A serial should be integer in the temp.A serial8> > should be int8.If the table does not have a serial or you did not select> > it, then the serialasint gets ignored.> > Just a thought: why don't you> > CREATE TEMP TABLE foo (> serno INT,> ...> ...> ...> ) WITH NO LOG;> > Then run your select as> > INSERT INTO foo> SELECT * FROM bar...> > ???> > -- > Bye now,> Obnoxio> > "I'm astonished anyone pays real money for this crap."> -- Cosmo> > -- > This message has been scanned for viruses and> dangerous content by OpenProtect(http://www.openprotect.com), and is> believed to be clean.>