OIDs as object handles?

From: Dave Trombley <dtrom(at)bumba(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: OIDs as object handles?
Date: 2001-12-30 05:34:46
Message-ID: 3C2EA776.6030108@bumba.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Greetings!

There is a particular feature I find myself wanting: Given a
table row, I'd like a handle to that row in storage so that I may access
it again quickly (ie. without the overhead of a SELECT). I was
originally under the impression that the oid would suffice for this
purpose, but I encountered some documentation which indicated that oid
numbers might not be unique in a given table, so it seems this
functionality could not be present after all.

Also, could someone explain the following (possibly related)
error? My syntax may be completely off, but I'm trying to do just what
I describe above:

test=# CREATE TABLE foo (a int, b int);
CREATE
test=# CREATE TABLE bar (c foo, d, int);
CREATE
test=# INSERT INTO foo VALUES(3,4);
INSERT 19839 1
test=# INSERT INTO bar VALUES(19839::foo, 6);
INSERT 19840 1
test=# SELECT bar.c.a FROM bar;
ERROR: fmgr_info: function 19839: cache lookup failed

Cheers,
dj trombley
<dtrom(at)bumba(dot)net>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-12-30 17:29:09 Re: OIDs as object handles?
Previous Message Tom Lane 2001-12-29 23:07:57 Re: Casting Varchar to Numeric