[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [HACKERS] Error message for CREATE VIEW is confusing
From:       Pavel Golub <pavel () microolap ! com>
Date:       2013-07-31 10:49:24
Message-ID: 951615835.20130731134924 () gf ! microolap ! com
[Download RAW message or body]

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:pavel@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
[prev in list] [next in list] [prev in thread] [next in thread]