Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2009-07-27 20:55:49
Subject: Re: SRPMs?
Previous:From: Jeff DavisDate: 2009-07-27 20:45:15
Subject: Re: WIP: Deferrable unique constraints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group