Re: Patch: Extend NOT NULL representation to pg_constraint - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Patch: Extend NOT NULL representation to pg_constraint
Date
Msg-id 12787.1285594967@sss.pgh.pa.us
Whole thread Raw
In response to Re: Patch: Extend NOT NULL representation to pg_constraint  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Bernd Helmle <mailings@oopsware.de> writes:
> What i can try is to record the inheritance information only in case of 
> attinhcount > 0. This would make maintenance of the pg_constraint records 
> for NOT NULL columns a little complicater though. Another thing we should 
> consider is that Peter's functional dependency patch was supposed to rely 
> on this feature (1), once it gets done. Not sure this still holds true....

Oh, right, that's a killer argument.  Finishing that patch still
requires that NOT NULL constraints have pg_constraint OIDs assigned,
which means they *have to* have pg_constraint rows to carry the OIDs.
So forget the whole thing; we'll just eat the space penalty.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: A small update for postgresql.conf.sample
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: A small update for postgresql.conf.sample