From dd7e54a17ffed5767cd9af175024c60df2b1951c Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Thu, 22 Jan 2009 17:27:55 +0000 Subject: Automatic view update rules Bernd Helmle --- src/backend/rewrite/rewriteHandler.c | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'src/backend/rewrite/rewriteHandler.c') 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: -- cgit v1.2.3