Обсуждение: RI Trigger Names

I am wondering if there is a TODO to make the names for RI constraints incorporate the name of the constraint they
implementto make it easier for humans to see what is going on.  Something like  

RI_myconstraintname_Trigger

instead of

RI_ConstraintTrigger_111633344.

I looked in the TODO list and only found these:

-Make foreign key constraints clearer in dump file
-Make other constraints clearer in dump file

Thanks!

Ian

On Mon, 16 Sep 2002, Ian Harding wrote:

> I am wondering if there is a TODO to make the names for RI constraints
> incorporate the name of the constraint they implement to make it
> easier for humans to see what is going on.  Something like
>
> RI_myconstraintname_Trigger
>
> instead of
>
> RI_ConstraintTrigger_111633344.
>
> I looked in the TODO list and only found these:
>
> -Make foreign key constraints clearer in dump file
> -Make other constraints clearer in dump file

Not specifically, but it might be a good idea to do for 7.4
since it'll also give you some limited control over the firing
order of multiple fk constraints on the same table.

"Ian Harding" <ianh@tpchd.org> writes:
> I am wondering if there is a TODO to make the names for RI constraints
> incorporate the name of the constraint they implement to make it
> easier for humans to see what is going on.

No, there isn't; as of 7.3 it doesn't seem necessary (pg_constraint
table is the thing you'd be looking at).

            regards, tom lane

Ian Harding wrote:
>
> I am wondering if there is a TODO to make the names for RI constraints incorporate the name of the constraint they
implementto make it easier for humans to see what is going on.  Something like 
>
> RI_myconstraintname_Trigger
>
> instead of
>
> RI_ConstraintTrigger_111633344.

Doesn't strike me as a good idea, since it'd imply a different
max length of constraint names than NAMEDATALEN.


Jan

>
> I looked in the TODO list and only found these:
>
> -Make foreign key constraints clearer in dump file
> -Make other constraints clearer in dump file
>
> Thanks!
>
> Ian
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me.                                  #
#==================================================
JanWieck@Yahoo.com #