keeping OID's when copying table - Mailing list pgsql-sql

Hi folks,

Using 6.3.2 in Linux and trying to clean up some tables by getting rid
of dead columns, but need to preserve the OID's... The FAQ in "3.17)
What is an oid? What is a tid?" describes this process to copy a
table, keeping the OID's:

        CREATE TABLE new_table (mycol int);
        INSERT INTO new_table SELECT oid, mycol FROM old_table;

But I tried this and it failed:

  dmlists=> create table test (acctname text not null);
  CREATE
  dmlists=> create table test2 (acctname text not null);
  CREATE
  dmlists=> insert into test2 select oid, acctname from test;
  ERROR:  Type of oid does not match target column acctname

How can I do this?

thanks,
Michael

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com