Postgres Pro
Downloads
Home   >   mailing lists

Re: Combining insert rules on views with functions - Mailing list pgsql-novice

From Tom Lane
Subject Re: Combining insert rules on views with functions
Date
Msg-id 23729.1442463244@sss.pgh.pa.us
Whole thread Raw
In response to Combining insert rules on views with functions  (Bastiaan Olij <bastiaan@basenlily.me>)
Responses Re: Combining insert rules on views with functions  (Bastiaan Olij <bastiaan@basenlily.me>)
List pgsql-novice
Tree view 
Bastiaan Olij <bastiaan@basenlily.me> writes:
> Would a before insert trigger work on a view as well?

Ah, sorry, wasn't paying close-enough attention.

For a view, you can only provide an INSTEAD OF trigger, and that feature
only exists in fairly recent PG releases.  But if you're running such a
release then I recommend looking into that way.  Rules are, um, not the
best part of Postgres.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Combining insert rules on views with functions
Next
From: Bastiaan Olij
Date:
Subject: Re: Combining insert rules on views with functions