summaryrefslogtreecommitdiff
path: root/src/tutorial/basics.source
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2024-04-28 14:34:21 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2024-04-28 14:34:21 -0400
commit617a23927249c78f23ef005aaa78b508570f4cc8 (patch)
tree94732604d59b783c17d05d5a2ccc6582c4b9af11 /src/tutorial/basics.source
parent1748379b636152b6633498c6488fd98aa015bc99 (diff)
Throw a more on-point error for functions depending on columns.
ALTER COLUMN TYPE wasn't expecting to find any pg_proc objects depending on the column whose type is to be altered. That indeed wasn't possible when this code was written, but it is possible since we introduced new-style SQL function bodies. It's about as difficult to fix this case as it is to fix dependent views, and we've been punting on those for years, so I don't feel too awful about punting for functions too. (I sure wouldn't risk back-patching such code.) So just throw a more user-facing error. Also, adjust some of the existing comments to reflect that these are all pretty much the same issue. (This patch also fixes it so we will tolerate finding such a dependency during ALTER COLUMN SET EXPRESSION; in that, we need not do anything to the function, so no error is wanted. That problem is new in HEAD.) Per bug #18449 from Alexander Lakhin. Back-patch to v14 where we added new-style SQL functions. Discussion: https://postgr.es/m/18449-f8248467aaa294d5@postgresql.org
Diffstat (limited to 'src/tutorial/basics.source')
0 files changed, 0 insertions, 0 deletions