Skip to content

Functions taking parameters of type view cannot be created #102

@koichi-szk

Description

@koichi-szk

Submitted by Abbas Butt, 2014-01-27.

See sourceforge bug tracker for details.

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions