views - Mailing list pgsql-hackers

From Andrzej Barszcz
Subject views
Date
Msg-id CAOUVqAxVFt5u6JXo_Vic6LC17eOBYccc8S2=FynqxXBED5DsVg@mail.gmail.com
Whole thread Raw
Responses Re: views
List pgsql-hackers
Dear hackers,

I would be happy when checkRuleResultList in rewriteDefine.c lost so strict conditions for returning clause. Are there any reasons to have such restriction for views ?
What I mean in short:

 create view ... as select MAIN_TABLE ... joins ...

1. Updating view means updating MAIN_TABLE
2. I want to return after insert at least primary key

No rule system, no trigger INSTEAD OF give me such possibility but I know that it's possible after modification of checkRuleResultList.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres with pthread
Next
From: Adam Brusselback
Date:
Subject: Re: Postgres with pthread