Thanks for reporting.
*RM created:* https://redmine.postgresql.org/issues/1924
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Thu, Nov 3, 2016 at 12:30 AM, Albin, Lloyd P wrote:
> If you try and edit a view that does not use Check O
If you try and edit a view that does not use Check Option and has DISTINCT, the
view will fail to be updated. Here an example to cause the failure.
CREATE TABLE x (y varchar, z int);
CREATE VIEW v AS SELECT DISTINCT ON (y) y, z FROM x ORDER BY y, z DESC;
Right click on the view and select Proper
