From: Alke <alke@iol.it>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: OID and PL/pgSQL trigger :-(
Date: Fri, 20 Aug 1999 22:51:07 +0200
Message-ID: <37BDBFBA.5370AFE3@iol.it> (raw)
Hy all!
I would like to use OIDs as a primary key on every table of my db,
because this seem to me a very smart thing to do..... but after some
experiment, I've decided to create a SERIAL field on every table, and to
use it as the primary key, and to abandon OIDs...
This is an example of what I whould like to write (and I can't):
CREATE FUNCTION firstTable_DelCascade() RETURNS OPAQUE AS '
BEGIN
DELETE FROM anotherTable WHERE anotherTable.OIDfromFirstTable =
OLD.OID;
RETURN OLD;
END;
' LANGUAGE 'plpgsql';
Well, this can't work because OLD is of type RECORD, and type record
have no OID :-(
(this is what I found in the docs, about RECORD:
"Only the user attributes of a table row are accessible in the row, no
Oid or other system attributes (hence the row could be from a view and
view rows don't have useful system attributes)" )
The main question is: can I get the OID of the OLD/NEW record in
triggers?
A more general question is: what is the usefulness of OIDs, if I can't
use them in trigger?
Paolo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: alke@iol.it, pgsql-general@postgresql.org
Subject: Re: OID and PL/pgSQL trigger :-(
In-Reply-To: <37BDBFBA.5370AFE3@iol.it>
References: <37BDBFBA.5370AFE3@iol.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox