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 pa...@microolap.com 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

[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 **