diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-29 06:05:27 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-29 06:05:27 +0000 |
| commit | 8e80dbb849cc63f6652a5fc645fa4d1e136c3c4c (patch) | |
| tree | 83d3a1d8be832b970d4d195b16a104188dd6edbd | |
| parent | bf59ccc7d80739fec98c7c1eacdc41460780f741 (diff) | |
| download | postgresql-8e80dbb849cc63f6652a5fc645fa4d1e136c3c4c.tar.gz postgresql-8e80dbb849cc63f6652a5fc645fa4d1e136c3c4c.zip | |
Rephrase 'Cannot insert into a view' and related messages, per
pghackers discussion around 31-Jul-02.
| -rw-r--r-- | src/backend/rewrite/rewriteHandler.c | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/src/backend/rewrite/rewriteHandler.c b/src/backend/rewrite/rewriteHandler.c index e526ffefd6b..b183f85f08a 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 - * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteHandler.c,v 1.106 2002/08/26 17:53:58 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteHandler.c,v 1.107 2002/08/29 06:05:27 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1237,13 +1237,16 @@ QueryRewrite(Query *parsetree) switch (query->commandType) { case CMD_INSERT: - elog(ERROR, "Cannot insert into a view without an appropriate rule"); + elog(ERROR, "Cannot insert into a view" + "\n\tYou need an unconditional ON INSERT DO INSTEAD rule"); break; case CMD_UPDATE: - elog(ERROR, "Cannot update a view without an appropriate rule"); + elog(ERROR, "Cannot update a view" + "\n\tYou need an unconditional ON UPDATE DO INSTEAD rule"); break; case CMD_DELETE: - elog(ERROR, "Cannot delete from a view without an appropriate rule"); + elog(ERROR, "Cannot delete from a view" + "\n\tYou need an unconditional ON DELETE DO INSTEAD rule"); break; default: elog(ERROR, "QueryRewrite: unexpected commandType %d", |