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

#1

On 11/26/05, Scott Simpson <Scott.Simpson (AT) computer (DOT) org> wrote:

Quote:

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

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#2

On 11/29/05, Norberto Meijome <sys (AT) meijome (DOT) net> wrote:

Quote:

Jaime Casanova wrote:
On 11/26/05, Scott Simpson <Scott.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.

Quote:

SELECT oid FROM your_referenced_table;

oid is an especial field that is

Quote:

present in all row unless you had
specified WITHOUT OIDS...

i think in 8.1

Quote:

WITHOUT OIDS is the DEFAULT...

it's not a good idea to do what you want to

Quote:

do... use a serial instead

Quote:

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 al=
ter
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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-novice mailing.database.pgsql-novice

Re: [NOVICE] How do I get an OID from a record in table? - 11-26-2005 , 06:12 PM

Re: [NOVICE] How do I get an OID from a record in table? - 11-29-2005 , 07:56 AM