Обсуждение: Missing RULEs from VIEWs and their format

Поиск
Список
Период
Сортировка

Missing RULEs from VIEWs and their format

От
Erwin Brandstetter
Дата:
Hi developers!

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;

Regards
Erwin

Re: Missing RULEs from VIEWs and their format

От
Guillaume Lelarge
Дата:
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 :)


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

Re: Missing RULEs from VIEWs and their format

От
Erwin Brandstetter
Дата:
On 08.04.2010 22:38, guillaume@lelarge.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


Re: Missing RULEs from VIEWs and their format

От
Guillaume Lelarge
Дата:
Le 09/04/2010 15:03, Erwin Brandstetter a écrit :
> On 08.04.2010 22:38, guillaume@lelarge.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.

Oh, great.

> And I do try to verify my findings before reporting. Wouldn't be much
> help, if I provided noise instead of insight, right?

Right :)

> So, the accumulation of reports is much rather a sign of bad timing on
> my side than of quality issues.
>

No problem.

Anyways, this is fixed. Thanks for your report.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com