Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Troels Arvin <troels(at)arvin(dot)dk>, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE
Date: 2004-10-24 14:30:09
Message-ID: 8379.1098628209@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Neil Conway <neilc(at)samurai(dot)com> writes:
> Tom Lane wrote:
>> Possibly we should make ALTER COLUMN strip any implicit coercions that
>> appear at the top level of the default expression before it adds on the
>> implicit coercion to the new column datatype.

> That seems like a kludge. When processing a column default expression, we:

> (1) Accept the default's raw parsetree from the parser
> (2) Convert it to a cooked parsetree via transformExpr()
> (3) Add a coercion to the table's column type

> Can't we save the cooked parsetree that we produced in #2?

Not without an initdb (to have another column to put it in). And it
would produce exactly the same result anyway, because the only way there
could be implicit coercion steps at the top of the expression is because
step 3 put them there.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dennis Bjorklund 2004-10-24 15:10:37 Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE
Previous Message Jan Wieck 2004-10-24 14:15:00 Re: [Slony1-general] Thread-safety detection on HP-UX

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-10-24 14:39:35 Re: First set of OSDL Shared Mem scalability results, some
Previous Message Dennis Bjorklund 2004-10-24 11:11:15 Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE