diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-01-27 12:40:15 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-01-27 12:40:15 +0000 |
| commit | 5fe3da927b2857761f9206d9fc597cf5321d9638 (patch) | |
| tree | b8cab00d0e561d46ba4eb6ef9428ecfd85fd5a33 /src/backend/rewrite/rewriteHandler.c | |
| parent | c0f92b57dc91126248d80462ac31497c091a9939 (diff) | |
| download | postgresql-5fe3da927b2857761f9206d9fc597cf5321d9638.tar.gz postgresql-5fe3da927b2857761f9206d9fc597cf5321d9638.zip | |
Revert updatable views
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 7cfeacb7305..336ae829ce2 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.184 2009/01/22 20:16:06 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/rewrite/rewriteHandler.c,v 1.185 2009/01/27 12:40:15 petere Exp $ * *------------------------------------------------------------------------- */ @@ -1899,20 +1899,20 @@ QueryRewrite(Query *parsetree) { case CMD_INSERT: ereport(ERROR, - (errcode(ERRCODE_WRONG_OBJECT_TYPE), - errmsg("view is not updatable"), + (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), + errmsg("cannot insert into a view"), errhint("You need an unconditional ON INSERT DO INSTEAD rule."))); break; case CMD_UPDATE: ereport(ERROR, - (errcode(ERRCODE_WRONG_OBJECT_TYPE), - errmsg("view is not updatable"), + (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), + errmsg("cannot update a view"), errhint("You need an unconditional ON UPDATE DO INSTEAD rule."))); break; case CMD_DELETE: ereport(ERROR, - (errcode(ERRCODE_WRONG_OBJECT_TYPE), - errmsg("view is not updatable"), + (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), + errmsg("cannot delete from a view"), errhint("You need an unconditional ON DELETE DO INSTEAD rule."))); break; default: |