error on create rule.

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: error on create rule.
Date: 2002-05-03 11:10:07
Message-ID: 7DD34E6DF5CD1B4283DDAB96A855DCED2F32AD@vodabemail1.vodacom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message PGMailList 2002-05-03 11:16:10 Re: how to rollback transactions in a function?
Previous Message Wim 2002-05-03 10:26:51 Re: Limiting number of records to show.