Re: RI Constraint display

Then this is a distinction between the trigger name and
the constraint name?  The trigger name is  RI_ConstraintTrigger_437278
(or some such oid).  The trigger is the implementation of the constraint
so the trigger name is what I had expected to see.

Almost all of the system generated names, sequences, triggers, etc,
have constructed names.  $n for constrain names seems like an anomaly.

elein

On Thursday 26 December 2002 13:45, Tom Lane wrote:
> elein <elein@sbcglobal.net> writes:
> > Referential integrity constraints are displayed as $n.
>
> If you didn't assign a name to the constraint, that's what the generated
> names look like.  Try "CONSTRAINT foo FOREIGN KEY ...".
>
>             regards, tom lane

--
----------------------------------------------------------------------------------------
elein@varlena.com     Database Consulting     www.varlena.com
              I have always depended on the [QA] of strangers.