Thread: Rules on views - Changes from 8.4 to 9.1 ?
Hello. We have a system that has been running using PostgreSQL 8.4. We have now upgraded to PostgreSQL 9.1. The system has severalrules on views and now most of these does not seem to work anymore. It is rather simple rules with mainly only 1 replacementsql (update for 'on update' and insert for 'on insert'). Have something basic things changed on the rule system and if so, where do I find information about it ? Please help, Leif
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