Disallow USING clause when altering type of generated column - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Disallow USING clause when altering type of generated column
Date
Msg-id c7083982-69f4-4b14-8315-f9ddb20b9834@eisentraut.org
Whole thread Raw
Responses Re: Disallow USING clause when altering type of generated column
List pgsql-hackers
A USING clause when altering the type of a generated column does not 
make sense.  It would write the output of the USING clause into the 
converted column, which would violate the generation  expression.

This patch 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.

discovered by Jian He at [0]

[0]: 
https://www.postgresql.org/message-id/CACJufxEGPYtFe79hbsMeOBOivfNnPRsw7Gjvk67m1x2MQggyiQ@mail.gmail.com



pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Conflict detection and logging in logical replication
Next
From: Amit Kapila
Date:
Subject: Re: Taking into account syncrep position in flush_lsn reported by apply worker