Re: add column sillyness - Mailing list pgsql-general

From Bruce Momjian
Subject Re: add column sillyness
Date
Msg-id 200312092337.hB9Nbxk19451@candle.pha.pa.us
Whole thread Raw
In response to add column sillyness  (Thomas Zehetbauer <thomasz@hostmaster.org>)
Responses Re: add column sillyness
List pgsql-general
"I'm tired of MySQL being beaten up by the PostgreSQL guys.  I am going
to fight back!  Where is my sword?"

---------------------------------------------------------------------------

Thomas Zehetbauer wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: add column sillyness
Next
From: Bruce Momjian
Date:
Subject: Re: Making a tree with "millions and millions" of dynamic