add column sillyness
От | Thomas Zehetbauer |
---|---|
Тема | add column sillyness |
Дата | |
Msg-id | 1070656011.22236.79.camel@tom.geizhals.at обсуждение исходный текст |
Ответы |
Re: add column sillyness
Re: add column sillyness Re: add column sillyness Re: add column sillyness Re: add column sillyness Re: add column sillyness Re: add column sillyness |
Список | pgsql-general |
Why do I have to use FOUR queries to accomplish the same result I can get from MySQL with only ONE query: alter table users add column $ColumnName text; alter table users alter column $ColumnName set default ''; update users set t_shirt_size='' where $ColumnName is null; alter table users alter column $ColumnName set not null; MySQL is CLEARLY SUPERIOR in terms of - usability - see above - performance - uses index for for min()/max() - reliability - no need to use vacuum - no need to dump and restore databases for version upgrade - never screwed up any of my databases I would therefore urgently recommend that 1) development of postgresql shall be immediately ceased 2) any resources gained thereby (developers, mirrors) shall be donated to MySQL 3) code produced by the former postgresql developers shall be subject to a mandatory peer review before it is included in MySQL Regards Tom
В списке pgsql-general по дате отправления: