search

pavanvd / postgres-xl

Public Postgres-XL repository
Mozilla Public License 2.0
4 stars 3 forks source link

Type corresponding to a view does not exist on datanode #5

Open pavanvd opened 9 years ago

pavanvd commented 9 years ago

Issue by pavanvd Monday Jun 29, 2015 at 05:32 GMT Originally opened as https://github.com/pavanvd/Postgres-XL-Private/issues/5

Here is a representative failure from regression testcase "updatable_view"

  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;
+ ERROR:  type rw_view1 does not exist

Since views are only created on the coordinators, it seems that this error could be coming from the datanodes as CREATE FUNCTION DDLs are executed on all the nodes.