Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id WAA77326 for ; Tue, 2 Feb 1999 22:55:29 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id WAA19807; Tue, 2 Feb 1999 22:55:01 -0500 (EST) From: Bruce Momjian Message-Id: <199902030355.WAA19807@candle.pha.pa.us> Subject: Re: [SQL] keeping OID's when copying table In-Reply-To: <19990203004227.6377.rocketmail@send102.yahoomail.com> from Michael Olivier at "Feb 2, 1999 4:42:27 pm" To: molivier@yahoo.com (Michael Olivier) Date: Tue, 2 Feb 1999 22:55:01 -0500 (EST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > 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? 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. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026