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(at)sbcglobal(dot)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(at)varlena(dot)com Database Consulting www.varlena.com
I have always depended on the [QA] of strangers.