Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch
Дата
Msg-id BANLkTi=71xatSXLEHxLQ5U3d75_vQ=TpQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, Jun 16, 2011 at 1:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Possible solution is to leave bootstrap's behavior alone, and have a
> step during initdb's post-bootstrap stuff that creates a matching
> pg_constraint row for every pg_attribute entry that's marked attnotnull.

That seems like a pretty good solution.

> I have a feeling that omitting these entries for system catalogs would
> bite us in other ways down the road, even if inheritance were the only
> soft spot right now.

I share that feeling.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pg_upgrade using appname to lock out other users
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: use less space in xl_xact_commit patch