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.
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 |