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 ********** Error ********** ERROR: "customer_v" is not a view SQL-state: 42809 Should we change error message to something like "customer_v" has wrong object type" (according to errcode appendix)? Or should we change word "view" to "regular view" since we have "materialized" already, e.g. "customer_v" is not a regular view"? -- With best wishes, Pavel mailto:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
