Re: [SQL] keeping OID's when copying table

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> OK, I think Tom Lane fixed this by generating an error in 6.5 beta.

>> dmdemo=> INSERT INTO new_table (oid, mycol) SELECT oid, mycol FROM
>> dmdemo-> old_table;
>> INSERT 837644 1

Hmm, what version did you do this with? It would fairly reliably crash
the backend in recent times, so a week or two ago I put in a temporary
check to generate an error instead. I would like to see INSERT or
UPDATE able to set the OID field; but we're too close to 6.5 release
to think about making that work for 6.5.

Right now the only way to preserve OIDs is to use COPY WITH OIDS.

regards, tom lane