Re: ALTER TABLE TODO items
От | Christopher Kings-Lynne |
---|---|
Тема | Re: ALTER TABLE TODO items |
Дата | |
Msg-id | 409AEB60.1010503@familyhealth.com.au обсуждение исходный текст |
Ответ на | Re: ALTER TABLE TODO items (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: ALTER TABLE TODO items
|
Список | pgsql-hackers |
> 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. Seems reasonable. > 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. Yeah, I was thinking along those lines. I don't now though... What happens with ordering of operations in the ALTER TABLE statement? Like if I put an alter TYPE and a SET STORAGE in the same statement (wiht commas between), in what order will things happen? Is it deterministic? Is it documented? Are there situations where a crazy collection of 20 commands in a single ALTER TABLE will have unpredictable effects? Also, should the syntax be SET TYPE, not just TYPE? Chris
В списке pgsql-hackers по дате отправления: