Обсуждение: 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