add column sillyness

From: Thomas Zehetbauer <thomasz(at)hostmaster(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: add column sillyness
Date: 2003-12-05 20:26:51
Message-ID: 1070656011.22236.79.camel@tom.geizhals.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory S. Williamson 2003-12-05 20:43:24 FW: Postgres 7.4 runing on BSD
Previous Message Keith C. Perry 2003-12-05 20:01:41 Re: Perl / mod_perl / PostgreSQL was: Good open source mailing list system PHP / Postgresql