From: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
---|---|
To: | Zeugswetter Andreas SARZ <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
Cc: | "'Jan Wieck'" <jwieck(at)debis(dot)com>, "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
Subject: | Re: AW: [HACKERS] triggers, views and rules (not instead) |
Date: | 1998-02-22 11:26:45 |
Message-ID: | 34F00B75.67F737D@sable.krasnoyarsk.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Zeugswetter Andreas SARZ wrote:
> Ok, to sum it up:
> 1. We need and want the select part of the rewrite rules.
Agreed.
> 2. for the insert/update/delete rules the old instance rules system
> was much more appropriate. TODO: dig up the old code
> and merge it with the current trigger Implementation
> it must be pretty much the wanted functionality (it
> supported sql)
??? Old instance rules system was removed by Jolly & Andrew and so
it never supported SQL. I hope that Jan will give us PL/pgSQL soon
and it will be used for triggers, without changing current trigger
implementation...
> 3. the CURRENT keyword in the i/u/d rewrite rules is stupid
> and should be disabled, destroyed and burned in hell
Agreed, if standard hasn't it. I know that OLD & NEW are in standard,
for triggers atleast.
> 4. To stick to the mainstream we should enhance the trigger
> syntax, and forget the rule stuff for i/u/d
Yes. Statement level triggers give the same functionality as rewrite
i/u/d rules. We could let them to return something special to skip
user' i/u/d itself, isn't it the same as INSTEAD ?
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Maurice Gittens | 1998-02-22 11:51:55 | Re: [HACKERS] How To free resources used by large object Relations? |
Previous Message | Vadim B. Mikheev | 1998-02-22 10:47:07 | Re: [HACKERS] How To free resources used by large object Relations? |