Re: Named constraints

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Named constraints
Date: 2002-05-23 03:41:11
Message-ID: 20020522234003.O76808-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 22 May 2002, Stephan Szabo wrote:

> On Wed, 22 May 2002, Francisco Reyes wrote:
> > GroupID integer
> > constraint fkgroup
> > references Groups,
>
> Nope, that's right, it's just that the trigger
> names aren't the same as the constraint name.

Would be nice if the triggers used more meaninful names.

> If you violate the constraint it should use the
> given names, and when drop constraint works with
> fk constraints it'll use them as well.

Is there a way to list the constraints?
I did not see any '\d' parameter to list them.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-05-23 04:02:59 Re: Named constraints
Previous Message Stephan Szabo 2002-05-23 03:29:18 Re: Named constraints