pgsql: Remove obsolete prohibition on function name matching a columnn - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Remove obsolete prohibition on function name matching a columnn
Date
Msg-id E1fUwXC-00020S-60@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Remove obsolete prohibition on function name matching a column name.

ProcedureCreate formerly threw an error if the function to be created
has one argument of composite type and the function name matches some
column of the composite type.  This was a (very non-bulletproof) defense
against creating situations where f(x) and x.f are ambiguous.  But we
don't really need such a defense in the wake of commit b97a3465d, which
allows us to deal with such situations fairly cleanly.  This behavior
also created a dump-and-reload hazard, since a function might be
rejected if a conflicting column name had been added to the input
composite type later.  Hence, let's just drop the check.

Discussion: https://postgr.es/m/CAOW5sYa3Wp7KozCuzjOdw6PiOYPi6D=VvRybtH2S=2C0SVmRmA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/45e98ee730621fd34d0a132343cb3f906ccc8416

Modified Files
--------------
src/backend/catalog/pg_proc.c | 15 ---------------
1 file changed, 15 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Consider syntactic form when disambiguating function vs columnr
Next
From: Tom Lane
Date:
Subject: pgsql: Fix excessive enreferencing in jsonb-to-plperl transform.