Referential Integrity Triggers
The tgname field in pg_trigger for referential
integrity constraints is of the form:
RI_ConstraintTrigger_<oid>. I was just wondering what
the OID references as I can find nothing in the system
tables with the specified OID.
Regards,
John Bell
http://movies.yahoo.com.au - Yahoo! Movies
- Vote for your nominees in our online Oscars pool.
=?iso-8859-1?q?John=20Bell?= <jbellpostgres@yahoo.com.au> writes:
The tgname field in pg_trigger for referential
integrity constraints is of the form:
RI_ConstraintTrigger_<oid>. I was just wondering what
the OID references
Nothing whatever, AFAIK --- it's just added to make the trigger name
unique.
regards, tom lane
On Mon, 11 Mar 2002, [iso-8859-1] John Bell wrote:
The tgname field in pg_trigger for referential
integrity constraints is of the form:
RI_ConstraintTrigger_<oid>. I was just wondering what
the OID references as I can find nothing in the system
tables with the specified OID.
IIRC, it's just getting an oid to use for making a unique
name.
Stephan Szabo wrote:
On Mon, 11 Mar 2002, [iso-8859-1] John Bell wrote:
The tgname field in pg_trigger for referential
integrity constraints is of the form:
RI_ConstraintTrigger_<oid>. I was just wondering what
the OID references as I can find nothing in the system
tables with the specified OID.IIRC, it's just getting an oid to use for making a unique
name.
YDRC (you do recall correct).
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com