Received: from send102.yahoomail.com (send102.yahoomail.com [205.180.60.90]) by hub.org (8.9.2/8.9.1) with SMTP id TAA59516 for ; Tue, 2 Feb 1999 19:39:59 -0500 (EST) (envelope-from molivier@yahoo.com) Message-ID: <19990203004227.6377.rocketmail@send102.yahoomail.com> Received: from [207.181.255.247] by send102.yahoomail.com; Tue, 02 Feb 1999 16:42:27 PST Date: Tue, 2 Feb 1999 16:42:27 -0800 (PST) From: Michael Olivier Subject: keeping OID's when copying table To: "pgsql-sql postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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