Re: [HACKERS] Error message for CREATE VIEW is confusing

2013-08-02 Thread Robert Haas
On Wed, Jul 31, 2013 at 6:49 AM, Pavel Golub wrote: > Hello, PostgreSQL. > > Let's assume we have created MATERIALIZED VIEW, e.g. > > CREATE MATERIALIZED VIEW customer_v AS SELECT ; > > Then one wants to redefine this view as a regular view, e.g. > > CREATE OR REPLACE VIEW customer_v AS ;

[HACKERS] Error message for CREATE VIEW is confusing

2013-07-31 Thread Pavel Golub
Hello, PostgreSQL. Let's assume we have created MATERIALIZED VIEW, e.g. CREATE MATERIALIZED VIEW customer_v AS SELECT ; Then one wants to redefine this view as a regular view, e.g. CREATE OR REPLACE VIEW customer_v AS ; Error is rising: ERROR: "customer_v" is not a view ** Err