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>
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 |