Re: Missing RULEs from VIEWs and their format

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: guillaume(at)lelarge(dot)info
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Missing RULEs from VIEWs and their format
Date: 2010-04-09 13:03:10
Message-ID: 4BBF258E.1090209@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On 08.04.2010 22:38, guillaume(at)lelarge(dot)info wrote:
> Le 07/04/2010 19:47, Erwin Brandstetter a écrit :
>
>> [...]
>> I have just filed ticket #167 concerning missing RULEs with VIEWs.
>> On a related but less important note: the formatting of rules might be
>> improved if was done like triggers are:
>>
>> -- status quo
>> CREATE OR REPLACE RULE on_delete AS
>> ON DELETE TO test DO INSTEAD DELETE FROM test2
>> WHERE test2.id = old.id;
>>
>> -- proposal
>> CREATE OR REPLACE RULE on_delete AS
>> ON DELETE
>> TO test
>> DO INSTEAD
>> DELETE FROM test2
>> WHERE test2.id = old.id;
>>
>>
> Hummm, /me feels ashamed but happy to see you came back with so many bug
> reports and feature requests :)
>

Hey, Guillaume, I have made notes over the last couple of months, but
never got around to report - for all the work piling on my desktop.
And I do try to verify my findings before reporting. Wouldn't be much
help, if I provided noise instead of insight, right?
So, the accumulation of reports is much rather a sign of bad timing on
my side than of quality issues.

Regards
Erwin

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Erwin Brandstetter 2010-04-09 14:20:19 Re: pgadmin 1.10.2 crashes on start
Previous Message Guillaume Lelarge 2010-04-09 10:38:15 Re: pdAgmin bug: incorrect creation script for indexes with user operator class