Postgres Pro
Downloads
Home   >   mailing lists

[BUGS] BUG #14900: MView not null constraint - Mailing list pgsql-bugs

From neil@postgrescompare.com
Subject [BUGS] BUG #14900: MView not null constraint
Date
Msg-id 20171112031621.31521.10140@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14900: MView not null constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14900
Logged by:          Neil Anderson
Email address:      neil@postgrescompare.com
PostgreSQL version: 10.1
Operating system:   OSx
Description:

This is probably not a bug but I spotted a question on StackOverflow that
I've been attempting to answer re: not null constraints and materialized
views.

(https://stackoverflow.com/questions/47242219/how-to-indicate-that-a-column-is-not-nullable-when-creating-a-materialized-view/47245081#47245081)

If it's not a bug should postgres support  
ALTER MATERIALIZED VIEW ALTER COLUMN column SET NOT NULL syntax?

Thanks,
Neil


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14897: Segfault on statitics SQL request
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14900: MView not null constraint