Thread: error on create rule.

error on create rule.

From
"Duncan Adams (DNS)"
Date:
hi all

just mucking around and came across the following

wire_dev=> create rule test_cab as on
wire_dev-> select to sys_cab
wire_dev-> do instead
wire_dev-> select * from sys_cab limit 10;
ERROR:  view rule for "sys_cab" must be named "_RETsys_cab"

i'm using
psql (PostgreSQL) 7.1.3