1 dnl Copyright (C) 2012, 2014 The Meme Factory, Inc., http://www.meme.com/
2 dnl Copyright (C) 2007, 2008, Karl O. Pinc
4 dnl This file is part of Gombe-MI.
6 dnl Gombe-MI is free software; you can redistribute it and/or modify
7 dnl it under the terms of the GNU General Public License as published by
8 dnl the Free Software Foundation; either version 3 of the License, or
9 dnl (at your option) any later version.
11 dnl This program is distributed in the hope that it will be useful,
12 dnl but WITHOUT ANY WARRANTY; without even the implied warranty of
13 dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 dnl GNU General Public License for more details.
16 dnl You should have received a copy of the GNU General Public License
17 dnl along with Gombe-MI. If not, see <http://www.gnu.org/licenses/>.
19 dnl Deliver an error message on an attempt to change a computed value.
20 dnl Karl O. Pinc <kop@meme.com>
24 include(`copyright.m4')
25 include(`constants.m4')
29 CREATE OR REPLACE FUNCTION
30 _error_immutable(col TEXT)
33 gmi_function_set_search_path
36 -- Raise error on an attempt to change an immutable column's value.
38 -- Copyright (C) 2014 The Meme Factory, Inc. http://www.meme.com/
39 -- GPL_notice(` --', `2007', `Karl O. Pinc <kop@meme.com>')
41 -- Syntax: _error_immutable(col TEXT)
44 -- col The immutable column.
49 -- Raises an exception.
52 -- Used when somebody tries to modify a view's computed column.
58 RAISE EXCEPTION '%: Attempt to insert or update a computed or otherwise immutable column'
64 grant_func_priv(`_error_immutable(TEXT)')