| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE TODO items |
| Date: | 2004-05-07 00:45:37 |
| Message-ID: | 26548.1083890737@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Out of interest what happens to other column features such as the
> existing statistics level and the existing storage spec? I guess these
> might have to change when type changes??
I left the statistic setting as-is (do you think that's wrong?) but the
storage spec gets reset to whatever the default for the new type is.
We could talk about doing something more complicated, such as "keep the
old setting if both old and new types support toasting, else reset to
new default". Not sure if that'd be better or not.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Scott | 2004-05-07 01:22:25 | psql 7.3.4 disagrees with NATURAL CROSS JOIN |
| Previous Message | Tom Lane | 2004-05-07 00:41:54 | Re: cast not IMMUTABLE? |