Re: NOT NULL markings for BKI columns - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: NOT NULL markings for BKI columns
Date
Msg-id 20150220220650.GR2500@alvh.no-ip.org
Whole thread Raw
In response to Re: NOT NULL markings for BKI columns  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: NOT NULL markings for BKI columns  (Andres Freund <andres@2ndquadrant.com>)
List 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 by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Idea: GSoC - Query Rewrite with Materialized Views
Next
From: Haribabu Kommi
Date:
Subject: Re: Question about durability and postgresql.