search

pavanvd / postgres-xl

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

Fail to create rule on temporary tables #10

Open pavanvd opened 9 years ago

pavanvd commented 9 years ago

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

Since temp tables are not created on remote coordinators, CREATE RULE on such tables could be failing if the DDL is replicated on a remote coordinator. 

***************
*** 1732,1737 ****
--- 1728,1734 ----
  create temp table tt_log(f1 int, data text);
  create rule insert_tt_rule as on insert to tt do also
    insert into tt_log values(new.*);
+ ERROR:  relation "tt_log" does not exist
  select insert_tt2('foollog','barlog') limit 1;