From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, José Arthur Benetasso Villanova <jose(dot)arthur(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Patch: Extend NOT NULL representation to pg_constraint |
Date: | 2010-09-27 13:42:47 |
Message-ID: | 12787.1285594967@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bernd Helmle <mailings(at)oopsware(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-09-27 13:45:57 | Re: A small update for postgresql.conf.sample |
Previous Message | Devrim GÜNDÜZ | 2010-09-27 13:42:36 | Re: A small update for postgresql.conf.sample |