Re: OID's

From: Matt <matt(at)kynx(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: OID's
Date: 2004-11-16 13:28:41
Message-ID: 1100611720.4227.49.camel@matt.kynx.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

> > > > OIDS are a system level implementation. They are no longer required
> > > > (you can make tables without OIDS) and they may go away someday.

What about tableoids? Are they from the same generator as row oids (and
hence may suffer wrap-around)? Or are they unique across the db?

I ask because I'm currently using them to join a single table to rows in
arbitrary tables, something like:

+-------------+
| JOINME |
+-------------+
| foreign_oid |
| foreign_id |
| ... |
+-------------+

Where foreign_oid is the tableoid of the table and foreign_id is the
(serial, not oid) id of the row in that table.

I dunno if it's bad design, but it's darn handy.

M

In response to

  • Re: OID's at 2004-11-16 12:20:46 from Tatsuo Ishii

Responses

  • Re: OID's at 2004-11-16 20:44:43 from Greg Stark

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2004-11-16 13:32:29 Re: 24x7x365 high-volume ops ideas
Previous Message Joolz 2004-11-16 13:26:38 CUM ON MY ASSHOLE