Postgres Pro
Downloads
Home   >   mailing lists

Re: support ALTER TABLE DROP EXPRESSION for virtual generated column - Mailing list pgsql-hackers

From Tom Lane
Subject Re: support ALTER TABLE DROP EXPRESSION for virtual generated column
Date
Msg-id 1818336.1743045303@sss.pgh.pa.us
Whole thread Raw
In response to support ALTER TABLE DROP EXPRESSION for virtual generated column  (jian he <jian.universality@gmail.com>)
Responses Re: support ALTER TABLE DROP EXPRESSION for virtual generated column
List pgsql-hackers
Tree view 
jian he <jian.universality@gmail.com> writes:
> the attached patch is to implement $subject.

Why would this be a good idea?  I don't see any principled fallback
definition of the column.  (No, "NULL" is not that.)  Certainly we
should support ALTER TABLE DROP COLUMN, but removing the expression
and not providing a substitute seems semantically nonsensical.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use CLOCK_MONOTONIC_COARSE for instr_time when available
Next
From: Tom Lane
Date:
Subject: Re: Add Postgres module info