From: | "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> |
---|---|
To: | PostgreSQL-SQL <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | RULE ... TO table.column |
Date: | 2001-04-15 21:52:57 |
Message-ID: | 20010415235257.A2630@frithjof |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-04-15 22:27:31 | Re: Same question about PostgreSql |
Previous Message | Lonnie Cumberland | 2001-04-15 21:27:55 | Now for the VARDATA, VARSIZE, and VARHDRSZ stuff |