Re: infinite recursion detected in rules for relation

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: infinite recursion detected in rules for relation
Date: 2015-02-13 14:47:55
Message-ID: CAKFQuwbdtNaTW0rf4V2eKY-tF4VH8H9xCJz+mQQvbgGpRvDhDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

User created rules are almost never the correct solution. There are too
many cavets and views can accomplish nearly everything that a user might
want.

David J.

On Friday, February 13, 2015, pinker [via PostgreSQL] <
ml-node+s1045698n5837822h6(at)n5(dot)nabble(dot)com> wrote:

> hmm I wanted to show only rows that was inserted today, so instead of
> who='me' wanted to filter for instance where timestamp_column=CURRENT_DATE.
>
> Yes, a view would be a solution but I thouhgt that's the case rules were
> made for? Isn't it?
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://postgresql.nabble.com/infinite-recursion-detected-in-rules-for-relation-tp5837697p5837822.html
> To unsubscribe from infinite recursion detected in rules for relation, click
> here
> <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5837697&code=ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb218NTgzNzY5N3wtMzI2NTA0MzIx>
> .
> NAML
> <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>

--
View this message in context: http://postgresql.nabble.com/infinite-recursion-detected-in-rules-for-relation-tp5837697p5837859.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bald, Glenn 2015-02-13 14:58:26 Re: Unknown error while running <> postgresql_installer_dc46cfee2c\getlocales.exe
Previous Message Merlin Moncure 2015-02-13 14:39:43 Re: How to hide stored procedure's bodies from specific user