I would like to use the oid as a unique key for a table but in creating
a test table and playing around with inserts, things don't seem to be
working as I thought they would.

create table test (
        key oid,
        desc varchar(30));

Then I do an insert

insert into test (desc) values ('info');

which returns 100448 1 (i'm assuming 100448 is the oid for that row).

But when I look at the table 100448 is not showing up on the key column

key|desc
---+----
   |info

What I expected was

key   |desc
------+----
100448|info

Where am I going wrong?

Chris

Reply via email to