Re: WIP: Deferrable unique constraints

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)googlemail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: Deferrable unique constraints
Date: 2009-07-27 20:54:39
Message-ID: 8e2dbb700907271354q4c84b2aem79c079f9e0c1bf10@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2009/7/27 Jeff Davis <pgsql(at)j-davis(dot)com>:
> On Mon, 2009-07-27 at 16:33 -0400, Tom Lane wrote:
>> If we did add another column to pg_trigger, I'd be a bit tempted to add
>> one to pg_constraint too.  tgconstrrelid for RI triggers is a mirror of
>> a pg_constraint column, and it seems like the index data perhaps should
>> be as well.  (Indeed, one of the thing that got me annoyed about this
>> kluge in the first place was that it broke that relationship without
>> changing the documentation.)
>
> That would work great for me, as I was planning to add such a column
> anyway for my "generalized index constraints" patch.
>

Yes that seems like the most sensible option to me.

- Dean

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-07-27 20:55:49 Re: SRPMs?
Previous Message Jeff Davis 2009-07-27 20:45:15 Re: WIP: Deferrable unique constraints