}

}

if (attrList==NIL)

ereport(ERROR,

(errcode(ERRCODE_INVALID_TABLE_DEFINITION),

errmsg("view must have at least one column")));

ERROR: relation "noview" does not exist

COMMENT ON VIEW toyemp IS 'is a view';

COMMENT ON VIEW toyemp IS NULL;

-- These views are left around mainly to exercise special cases in pg_dump.

CREATE TABLE view_base_table (key int PRIMARY KEY, data varchar(20));

CREATE VIEW key_dependent_view AS

SELECT * FROM view_base_table GROUP BY key;

ALTER TABLE view_base_table DROP CONSTRAINT view_base_table_pkey; -- fails

ERROR: cannot drop constraint view_base_table_pkey on table view_base_table because other objects depend on it

DETAIL: view key_dependent_view depends on constraint view_base_table_pkey on table view_base_table

HINT: Use DROP ... CASCADE to drop the dependent objects too.

CREATE VIEW key_dependent_view_no_cols AS

SELECT FROM view_base_table GROUP BY key HAVING length(data) > 0;

--

-- CREATE OR REPLACE VIEW

--

FROM ihighway ih,

ramp r

WHERE (ih.thepath ## r.thepath);

key_dependent_view| SELECT view_base_table.key,

view_base_table.data

FROM view_base_table

GROUP BY view_base_table.key;

key_dependent_view_no_cols| SELECT

FROM view_base_table

GROUP BY view_base_table.key

HAVING (length((view_base_table.data)::text) > 0);

mvtest_tv| SELECT mvtest_t.type,

sum(mvtest_t.amt) AS totamt

FROM mvtest_t

timestamptz_tbl|f

timetz_tbl|f

varchar_tbl|f

view_base_table|t

-- restore normal output mode

\a\t

--

COMMENT ON VIEW toyemp IS'is a view';

COMMENT ON VIEW toyemp ISNULL;

CREATETABLEview_base_table (keyintPRIMARY KEY, datavarchar(20));

SELECT*FROM view_base_tableGROUP BY key;

ALTERTABLE view_base_table DROPCONSTRAINT view_base_table_pkey;-- fails

SELECTFROM view_base_tableGROUP BY keyHAVING length(data)>0;