The following bug has been logged on the website:
Bug reference: 14900
Logged by: Neil Anderson
Email address: neil(at)postgrescompare(dot)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