]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Disallow USING clause when altering type of generated column
authorPeter Eisentraut <peter@eisentraut.org>
Thu, 29 Aug 2024 06:38:29 +0000 (08:38 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Thu, 29 Aug 2024 07:03:06 +0000 (09:03 +0200)
commit1c57ae795b3c0650cbac13e0f59f326ddc34c5d0
tree81f6a25a0ffd647ee1f804a191a08ac0cec873d0
parent5ff394503ce2b5b63239ec23fcaca1dc1d1ff049
Disallow USING clause when altering type of generated column

This does not make sense.  It would write the output of the USING
clause into the converted column, which would violate the generation
expression.  This adds a check to error out if this is specified.

There was a test for this, but that test errored out for a different
reason, so it was not effective.

Reported-by: Jian He <jian.universality@gmail.com>
Reviewed-by: Yugo NAGATA <nagata@sraoss.co.jp>
Discussion: https://www.postgresql.org/message-id/flat/c7083982-69f4-4b14-8315-f9ddb20b9834%40eisentraut.org
src/backend/commands/tablecmds.c
src/test/regress/expected/generated.out