Re: Rules on views - Changes from 8.4 to 9.1 ? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Rules on views - Changes from 8.4 to 9.1 ?
Date
Msg-id 510695DC.9060200@gmail.com
Whole thread Raw
In response to Rules on views - Changes from 8.4 to 9.1 ?  (Leif Jensen <leif@crysberg.dk>)
List pgsql-general
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
hasseveral rules on views and now most of these does not seem to work anymore. It is rather simple rules with mainly
only1 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.klaver@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: finding if a period is multiples of a given interval
Next
From: c k
Date:
Subject: Re: finding if a period is multiples of a given interval