pgsql: Fix dependency, when changing a function's argument/return type.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix dependency, when changing a function's argument/return type.
Date: 2017-06-16 08:48:52
Message-ID: E1dLmw0-0005F7-F1@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix dependency, when changing a function's argument/return type.

When a new base type is created using the old-style procedure of first
creating the input/output functions with "opaque" in place of the base
type, the "opaque" argument/return type is changed to the final base type,
on CREATE TYPE. However, we did not create a pg_depend record when doing
that, so the functions were left not depending on the type.

Fixes bug #14706, reported by Karen Huddleston.

Discussion: https://www.postgresql.org/message-id/20170614232259.1424.82774@wrigleys.postgresql.org

Branch
------
REL9_2_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/ac93a78b0e51b69bfccd7b548da4f2d4ebf7cf93

Modified Files
--------------
src/backend/commands/functioncmds.c | 32 +++++++++++++++++++++++++++++++
src/test/regress/expected/create_type.out | 31 ++++++++++++++++++++++++++++++
src/test/regress/sql/create_type.sql | 17 ++++++++++++++++
3 files changed, 80 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2017-06-16 14:03:01 pgsql: doc: Add section about logical replication restrictions
Previous Message Heikki Linnakangas 2017-06-16 08:37:44 pgsql: Fix dependency, when changing a function's argument/return type.