Re: Patch: Extend NOT NULL representation to pg_constraint

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch: Extend NOT NULL representation to pg_constraint
Дата
Msg-id 12787.1285594967@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Patch: Extend NOT NULL representation to pg_constraint  (Bernd Helmle <mailings@oopsware.de>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: A small update for postgresql.conf.sample
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: A small update for postgresql.conf.sample