Menu

#471 Functions taking parameters of type view cannot be created

Development Queue
open
nobody
5
2014-01-27
2014-01-27
Abbas Butt
No

Consider this test case taken from updatable_views.sql

CREATE TABLE base_tbl (a int PRIMARY KEY, b text DEFAULT 'Unspecified');
CREATE VIEW rw_view1 AS SELECT b AS bb, a AS aa FROM base_tbl;
CREATE FUNCTION rw_view1_aa(x rw_view1) RETURNS int AS $$ SELECT x.aa $$ LANGUAGE sql;

Note that the function being created takes a parameter of type rw_view1 which is a view.
We know that views are not created on datanodes.
When the system tries to create the function on the datanode it fails.

Discussion


Log in to post a comment.