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

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-advocacy(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] [HACKERS] Need concrete "Why Postgres not MySQL" bullet list
Date: 2003-08-22 06:49:25
Message-ID: 3F460A4D.28750.4D0091F@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

On 21 Aug 2003 at 21:30, Manfred Koizar wrote:

> On Thu, 21 Aug 2003 15:05:52 +0200, I wrote:
> >>Just wondering, what other databases has transactable DDLs?
> >
> >Firebird.
>
> Stop! I withdraw that statement. I must have mis-read some feature
> list :-(
>
> Tests with InterBase 6 showed that you can change metadata within a
> transaction, but when you ROLLBACK, metadata changes persist.

Well, isql documentation mentions that DDLs don't go to database unless you
commit and autoddl parameter defaults to true.

Looks like there definition of transactable does not include a rollback case.
Oops!

BTW any comments on storing an entire database in single file? I don't trust
any file system for performance and data integrity if I have single 100GB file.
I would rather have multiple of them..

Bye
Shridhar

--
Moore's Constant: Everybody sets out to do something, and everybody does
something, but no one does what he sets out to do.

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Autoresponder 2003-08-22 06:50:30 Re: My details
Previous Message Christopher Kings-Lynne 2003-08-22 06:40:32 Re: [GENERAL] Need concrete "Why Postgres not MySQL"

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-08-22 06:54:11 Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Previous Message Shridhar Daithankar 2003-08-22 06:47:41 Re: Buglist

Browse pgsql-hackers by date

  From Date Subject
Next Message Shridhar Daithankar 2003-08-22 06:54:11 Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Previous Message Shridhar Daithankar 2003-08-22 06:47:41 Re: Buglist