---Bruce Momjian <maillist@candle.pha.pa.us> wrote:
>
> Thank you for pointing out my error. It should be:
>
> CREATE TABLE new_table (mycol int);
> INSERT INTO new_table (oid, mycol) SELECT oid, mycol FROM
old_table;
>
> I have updated the FAQ.
Hmm... now I don't get an error, but the oid isn't preserved. This is
running 6.3.2 on RH Linux:
dmdemo=> CREATE TABLE new_table (mycol int);
CREATE
dmdemo=> CREATE TABLE old_table (mycol int);
CREATE
dmdemo=> insert into old_table values (33);
INSERT 837643 1
dmdemo=> select oid from old_table;
oid
------
837643
(1 row)
dmdemo=> INSERT INTO new_table (oid, mycol) SELECT oid, mycol FROM
dmdemo-> old_table;
INSERT 837644 1
dmdemo=> select oid from new_table;
oid
------
837644
(1 row)
Further suggestions?
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com