Project

General

Profile

« Previous | Next » 

Revision 12591

bugfix: schemas/util.sql: functions marked IMMUTABLE: changed to STABLE or VOLATILE where IMMUTABLE would cause preemptive inlining (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Function%20Volatility%20Categories%20**)

View differences:

trunk/schemas/util.sql
2072 2072
--
2073 2073

  
2074 2074
CREATE FUNCTION mk_keys_func(type regtype) RETURNS void
2075
    LANGUAGE sql VOLATILE
2075
    LANGUAGE sql
2076 2076
    AS $_$
2077 2077
-- keys()
2078 2078
SELECT util.mk_keys_func($1, ARRAY(
......
2096 2096
--
2097 2097

  
2098 2098
CREATE FUNCTION mk_keys_func(type regtype, cols col_cast[], name text DEFAULT 'keys'::text) RETURNS void
2099
    LANGUAGE sql VOLATILE
2099
    LANGUAGE sql
2100 2100
    AS $_$
2101 2101
SELECT util.create_if_not_exists($$
2102 2102
CREATE TYPE $$||util.prefixed_name($3||'_', $1)||$$ AS

Also available in: Unified diff