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 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').
Have something basic things changed on the rule system and if so, where do I find information about it ?
Please help,
Leif
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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 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.klaver@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general