diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-01-22 17:27:55 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-01-22 17:27:55 +0000 |
| commit | dd7e54a17ffed5767cd9af175024c60df2b1951c (patch) | |
| tree | 2932885551f282e1466c6bd1f31a35c4938c329c /src/backend/rewrite/rewriteHandler.c | |
| parent | 5841aa86eb67dabb0a54c81d21463002dfa7e358 (diff) | |
| download | postgresql-dd7e54a17ffed5767cd9af175024c60df2b1951c.tar.gz postgresql-dd7e54a17ffed5767cd9af175024c60df2b1951c.zip | |
Automatic view update rules
Bernd Helmle
Diffstat (limited to 'src/backend/rewrite/rewriteHandler.c')
| -rw-r--r-- | src/backend/rewrite/rewriteHandler.c | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/backend/rewrite/rewriteHandler.c b/src/backend/rewrite/rewriteHandler.c index 2e21fed213a..56549a55095 100644 --- a/src/backend/rewrite/rewriteHandler.c +++ b/src/backend/rewrite/rewriteHandler.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/rewrite/rewriteHandler.c,v 1.182 2009/01/01 17:23:47 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/rewrite/rewriteHandler.c,v 1.183 2009/01/22 17:27:54 petere Exp $ * *------------------------------------------------------------------------- */ @@ -1895,20 +1895,20 @@ QueryRewrite(Query *parsetree) { case CMD_INSERT: ereport(ERROR, - (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), - errmsg("cannot insert into a view"), + (errcode(ERRCODE_WRONG_OBJECT_TYPE), + errmsg("view is not updatable"), errhint("You need an unconditional ON INSERT DO INSTEAD rule."))); break; case CMD_UPDATE: ereport(ERROR, - (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), - errmsg("cannot update a view"), + (errcode(ERRCODE_WRONG_OBJECT_TYPE), + errmsg("view is not updatable"), errhint("You need an unconditional ON UPDATE DO INSTEAD rule."))); break; case CMD_DELETE: ereport(ERROR, - (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), - errmsg("cannot delete from a view"), + (errcode(ERRCODE_WRONG_OBJECT_TYPE), + errmsg("view is not updatable"), errhint("You need an unconditional ON DELETE DO INSTEAD rule."))); break; default: |