Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] ALTER COLUMN, trading a DOMAIN for its base datatype - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] ALTER COLUMN, trading a DOMAIN for its base datatype
Date
Msg-id 31285.1500496114@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] ALTER COLUMN, trading a DOMAIN for its base datatype  (C GG <cgg0007@gmail.com>)
List pgsql-general
Tree view 
C GG <cgg0007@gmail.com> writes:
> ... Is PostgreSQL smart enough to not have to rewrite the table and simply
> shed the domain for the underlying datatype?

Yes, in recent versions ... don't remember how far back exactly.

            regards, tom lane

pgsql-general by date:

Previous
From: C GG
Date:
Subject: [GENERAL] ALTER COLUMN, trading a DOMAIN for its base datatype
Next
From: Evan Martin
Date:
Subject: [GENERAL] Why would log_lock_waits affect a query plan?