Postgres Pro
Downloads
Home   >   mailing lists

Re: infinite recursion detected in rules for relation - Mailing list pgsql-general

From David G Johnston
Subject Re: infinite recursion detected in rules for relation
Date
Msg-id CAKFQuwbdtNaTW0rf4V2eKY-tF4VH8H9xCJz+mQQvbgGpRvDhDg@mail.gmail.com
Whole thread Raw
In response to Re: infinite recursion detected in rules for relation  (pinker <pinker@onet.eu>)
Responses Re: infinite recursion detected in rules for relation
List pgsql-general
Tree view
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] <[hidden email]> 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.
NAML

View this message in context: Re: infinite recursion detected in rules for relation
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How to hide stored procedure's bodies from specific user
Next
From: Ramesh T
Date:
Subject: Collection