Re: RI Trigger Names

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Ian Harding <ianh(at)tpchd(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: RI Trigger Names
Date: 2002-09-16 15:42:33
Message-ID: 20020916084110.L89802-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-09-16 15:43:06 Re: OID order = INSERT order?
Previous Message Shridhar Daithankar 2002-09-16 15:27:23 Re: database connectivty problem!