Received: from frithjof.reiner (b20.dialin.tuwien.ac.at [192.35.240.150]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3GG4Ru26878 for ; Mon, 16 Apr 2001 12:04:27 -0400 (EDT) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 2657 invoked by uid 500); 15 Apr 2001 21:52:57 -0000 From: "Albert REINER" Date: Sun, 15 Apr 2001 23:52:57 +0200 To: PostgreSQL-SQL Subject: RULE ... TO table.column Message-ID: <20010415235257.A2630@frithjof> Mail-Followup-To: PostgreSQL-SQL Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Archive-Number: 200104/252 X-Sequence-Number: 2602 Saluton, I am using ,---- | SELECT version(); | version | -------------------------------------------------------------------- | PostgreSQL 7.0.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1 | (1 row) `---- , and upgrading to 7.1 is not possible (it was hard enough to get the admin to upgrade from 6.5.3). While the docs say that I can create a rule on table.column, I get the error message: ,---- | litdb=> create rule no_update_on_journal_title__rl as | litdb-> on update to journal.title do instead nothing; | ERROR: attribute level rules currently not supported `---- Am I doing something wrong here, or do I have to work around this via ... where old.title = new.title ... (would this work?), or should I use a before-trigger? Are ``attribute level rules'' supported in 7.1 (so I can at least put a note into the code)? Thanks in advance, Albert.