Re: Rules on views - Changes from 8.4 to 9.1 ?

On 01/28/2013 02:19 AM, Leif Jensen wrote:
> Hello.
>
> We have a system that has been running using PostgreSQL 8.4. We have now upgraded to PostgreSQL 9.1. The system has several rules on views and now most of these does not seem to work anymore. It is rather simple rules with mainly only 1 replacement sql (update for 'on update' and insert for 'on insert').

Define not work?
Is there an error message being thrown?
Can you show a sample rule?

>
> Have something basic things changed on the rule system and if so, where do I find information about it ?

You can look at the release notes:

http://www.postgresql.org/docs/9.1/interactive/release.html

Feature changes are confined to major releases so you should look at the
Release 9.0 and Release 9.1 notes.

>
> Please help,
>
> Leif
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com