Re: pg_constraint

From: "Rod Taylor" <rbt(at)zort(dot)ca>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_constraint
Date: 2002-04-26 17:28:53
Message-ID: 1cc801c1ed47$d6e41fa0$ad02000a@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > The only problem with this is that I don't want the rename of a
> > constraint to have to fall over into the pg_depend table.
pg_depend
> > is currently happy with system OIDS or a Relation OID and some
unique
> > number to represent it -- much as pg_description wouldn't want to
know
> > the name of the constraint for the ability to add a comment to it.
>
> Good points, but I think those argue for assigning OIDs to
constraints
> after all. If that is what you want connum for then I have a *big*

Yes, OIDs are probably the right way to go.

> problem with it: aren't you assuming that connum will be distinct
from
> any attribute number that the relation might have? What's going to

As far as pg_depend goes, it doesn't care whether they overlap or not
as it knows the source (class) relation is pg_constraint.

Comment on stuff would need to be changed though.

> I had once thought that we could avoid assigning OIDs to rules and
> triggers, but learned differently as I got into the implementation.
> I'm thinking that constraints will be the same kind of thing; it'll
> be a lot easier if you give them OIDs.

Sounds like a plan. I'll

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-04-26 18:32:19 Re: Vote totals for SET in aborted transaction
Previous Message Marc G. Fournier 2002-04-26 16:58:06 Re: Vote totals for SET in aborted transaction