RE: temp tables and serial columns
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.> Subject: RE: temp tables and serial columns> Date: Fri, 9 Mar 2007 14:01:17 -0600> From: eemills@nationalbeef.com> To: informix-list@iiug.org> > Hmmm. OK, so I've never tried to alter a temp table... How about a> feature request to allow the alteration of temp tables?> > --EEM> ________________________________________> From: Bill64bits [mailto:garage_dba@hotmail.com] > Sent: Friday, March 09, 2007 1:25 PM> To: Everett Mills; informix-list@iiug.org> Subject: Re: temp tables and serial columns> > as I stated, you cannot do that.> You get: Error: Cannot alter temporary table (t)> ----- Original Message ----- > From: Everett Mills > To: informix-list@iiug.org > Sent: Friday, March 09, 2007 12:41 PM> Subject: RE: temp tables and serial columns> > Why not do this:> > Select into temp foo ...;> > alter table foo modify (my_serial_column integer);> > > --EEM> > ________________________________________> From: informix-list-bounces@iiug.org> [mailto:informix-list-bounces@iiug.org] On Behalf Of Bill64bits> Sent: Friday, March 09, 2007 11:34 AM> To: informix-list@iiug.org> Subject: temp tables and serial columns> > We are on IDS 9.4 .> One thing that has always annoyed me about serial columns is that they> become serial instead of integer> when you do a "select into temp x" .> If you are trying to duplicate a row for a customer, part, etc, except> for the id , you cannot update the temp> to change the id to 0 and do an insert back into the table to force a> new id to be generated.> Neither can you alter the temp table to make the column a plain old> integer.> You have to create table blah ( ...) with an integer where the serial> was and go from there.> That is a bit of a hassle if there are many columns.> > Is there any relief for this issue in IDS 10 or IDS 11 ?> Like "into temp t with no serial" or something like that?> _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list>; _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list