From: | Michael Olivier <molivier(at)yahoo(dot)com> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] keeping OID's when copying table |
Date: | 1999-02-04 21:34:33 |
Message-ID: | 19990204213433.2881.rocketmail@send103.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
---Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-04 21:42:32 | Re: [SQL] keeping OID's when copying tableu |
Previous Message | Jackson, DeJuan | 1999-02-04 21:00:47 | RE: [SQL] problem with join & count |