Skip site navigation (1) Skip section navigation (2)

Re: How do I get an OID from a record in table?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Norberto Meijome <sys(at)meijome(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do I get an OID from a record in table?
Date: 2005-11-29 13:55:32
Message-ID: c2d9e70e0511290555n4a6ce880lf85171f13e5e74ab@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 11/29/05, Norberto Meijome <sys(at)meijome(dot)net> wrote:
> Jaime Casanova wrote:
> On 11/26/05, Scott Simpson <Scott(dot)Simpson(at)computer(dot)org> wrote:

> If I create a table with an OID field type, how do I set that field
> type?
That is, I have to look up the OID value in another table somewhere to
> set
my OID field and I don't know how to do that. (I'm trying to get one
> field
to point to another record). ADVthanksANCE.


> SELECT oid FROM your_referenced_table;

oid is an especial field that is
> present in all row unless you had
specified WITHOUT OIDS...

i think in 8.1
> WITHOUT OIDS is the DEFAULT...

it's not a good idea to do what you want to
> do... use a serial instead


> Jaime,
>  if one is not specifically using OIDs (as you described above), is there
> any advantage to have tables defined WITH OIDs ? would it be better to alter
> the tables to WITHOUT OID (and then pg_dump and load again, i guess)
>
> thanks!
> Beto
>

The preferred way is to not use OID's in user tables... but AFAICS,
you will have no problem if you simply let them there (there is no
need for ALTERing and DUMPing)... i don't know if it will be a
reduction in the space if you don't have OIDs, will be?


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

pgsql-novice by date

Next:From: T. LackeyDate: 2005-11-29 16:35:30
Subject: saving a query and reults to a file.
Previous:From: George WeaverDate: 2005-11-29 13:30:43
Subject: Re: PGXML support for postgreSQL on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group