|
7 | 7 | * Portions Copyright (c) 1994, Regents of the University of California |
8 | 8 | * |
9 | 9 | * IDENTIFICATION |
10 | | - * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteHandler.c,v 1.106 2002/08/26 17:53:58 tgl Exp $ |
| 10 | + * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteHandler.c,v 1.107 2002/08/29 06:05:27 tgl Exp $ |
11 | 11 | * |
12 | 12 | *------------------------------------------------------------------------- |
13 | 13 | */ |
@@ -1237,13 +1237,16 @@ QueryRewrite(Query *parsetree) |
1237 | 1237 | switch (query->commandType) |
1238 | 1238 | { |
1239 | 1239 | caseCMD_INSERT: |
1240 | | -elog(ERROR,"Cannot insert into a view without an appropriate rule"); |
| 1240 | +elog(ERROR,"Cannot insert into a view" |
| 1241 | +"\n\tYou need an unconditional ON INSERT DO INSTEAD rule"); |
1241 | 1242 | break; |
1242 | 1243 | caseCMD_UPDATE: |
1243 | | -elog(ERROR,"Cannot update a view without an appropriate rule"); |
| 1244 | +elog(ERROR,"Cannot update a view" |
| 1245 | +"\n\tYou need an unconditional ON UPDATE DO INSTEAD rule"); |
1244 | 1246 | break; |
1245 | 1247 | caseCMD_DELETE: |
1246 | | -elog(ERROR,"Cannot delete from a view without an appropriate rule"); |
| 1248 | +elog(ERROR,"Cannot delete from a view" |
| 1249 | +"\n\tYou need an unconditional ON DELETE DO INSTEAD rule"); |
1247 | 1250 | break; |
1248 | 1251 | default: |
1249 | 1252 | elog(ERROR,"QueryRewrite: unexpected commandType %d", |
|