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.