Re: [GENERAL] Need concrete "Why Postgres not MySQL"

Поиск
Список
Период
Сортировка
От Hornyak Laszlo
Тема Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Дата
Msg-id Pine.LNX.4.21.0308231220120.22590-100000@tiger.tigrasoft.hu
обсуждение исходный текст
Ответ на Re: [GENERAL] Need concrete "Why Postgres not MySQL"  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-advocacy

<off>
Yep, I know, but that is not a reason. :)
</off>

Laci

On Fri, 22 Aug 2003, Jan Wieck wrote:

> Hornyak Laszlo wrote:
>
> > Hi all!
> >
> > Can someone explain me why is it usefull if the table created in
> > transaction disapears on rollback?
> > Anyway the progress db supports it, at least the version 9.
> > The other question: why is mysql enemy? Isn`t it just another RDBMS?
>
> Go to http://www.mysql.com, type "postgresql" into the search field (top
> right corner) and read through some of the links. Especially stuff like
> the subsections of
>
>      http://www.mysql.com/doc/en/Compare_PostgreSQL.html
>
> Then go to http://www.postgresql.org and try to find similar FUD. You
> will rather find something like this:
>
>      http://developer.postgresql.org/~petere/comparison.html
>
> This exercise will tell you who considers whom "enemy" and why some of
> us just "dislike" MySQL and their understanding of "fair".
>
>
> Jan
>
> >
> > Thanks,
> > Laszlo
> >
> > On Thu, 21 Aug 2003, Ian Barwick wrote:
> >
> >> On Thursday 21 August 2003 11:15, Shridhar Daithankar wrote:
> >> > On 21 Aug 2003 at 0:22, Ian Barwick wrote:
> >> > > * DDL
> >> > > - Data definition language (table creation statements etc.) in MySQL
> >> > > are not transaction based and cannot be rolled back.
> >> >
> >> > Just wondering, what other databases has transactable DDLs? oracle seems to
> >> > have autonomous transactions which is arthogonal.
> >>
> >> DB2 8.1 seems to support transaction-capable DDL. At least, a rollback
> >> following a CREATE TABLE causes the table to disappear. Haven't gone
> >> into it in any depth.
> >>
> >>
> >> Ian Barwick
> >> barwick@gmx.net
> >>
> >>
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 2: you can get off all lists at once with the unregister command
> >>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >>
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
> --
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me.                                  #
> #================================================== JanWieck@Yahoo.com #
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


В списке pgsql-advocacy по дате отправления:

Предыдущее
От: Autoresponder
Дата:
Сообщение: Re: Details
Следующее
От: Anastasios Hatzis
Дата:
Сообщение: Surveys & Studies: FLOSS - Usage of Free/Libre Open Source Software (PostgreSQL, etc.)