Re: NOT NULL markings for BKI columns

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: NOT NULL markings for BKI columns
Дата
Msg-id 20150220220650.GR2500@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: NOT NULL markings for BKI columns  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: NOT NULL markings for BKI columns  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund wrote:
> On 2015-02-15 12:54:45 -0500, Tom Lane wrote:
> > Andres Freund <andres@2ndquadrant.com> writes:

> > BTW, the precedent of PG_USED_FOR_ASSERTS_ONLY would suggest calling
> > this one PG_FORCE_NOT_NULL, or at least using underscores for word
> > breaks in whatever we end up calling it.
> 
> I've named it BKI_FORCE_(NOT_)?NULL.
> 
> So, I've implemented this - turned out to be a bit more work than I'd
> expected... I had to whack around the representation Catalog.pm returns
> for columns, but I think the new representation for columns is better
> anyway. Doesn't look too bad.

Just gave it a quick read, I think it's good.  +1 for your
implementation.

> I've also added BKI_FORCE_NULL as you mentioned it as being possibly
> useful, was easy enough. I haven't identified a user so far though, so
> we could just remove it if we want.

I think we should just save this part of the patch until some use turns up.



-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Idea: GSoC - Query Rewrite with Materialized Views
Следующее
От: Haribabu Kommi
Дата:
Сообщение: Re: Question about durability and postgresql.