Re: storage engine , mysql syntax CREATE TABLE t (i INT)

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: storage engine , mysql syntax CREATE TABLE t (i INT)
Дата
Msg-id 410428E7.8070808@bigfoot.com
обсуждение исходный текст
Ответ на Re: storage engine , mysql syntax CREATE TABLE t (i INT)  (Andreas Pflug <pgadmin@pse-consulting.de>)
Ответы Re: storage engine , mysql syntax CREATE TABLE t (i INT)
Список pgsql-hackers
Andreas Pflug wrote:

> Pierre Emmanuel Gros wrote:
> 
>> In mysql, we can wrote a create table like CREATE TABLE t (i INT) 
>> ENGINE = INNODB||BDB|;
>> where the storage engine is the innodb one. 
> 
> 
> MySQL needs this because they have a weird understanding of RDBMS.

This could be true, but the answer doesn't make sense, at least it's
in a perfect "mysql people" style. Isn't ? We don't need transactions,
we don't needs store procedure and so on...

> There's absolutely no sense in trying to transfer this stuff into 
> PostgreSQL. Use it as designed, and you'll never miss this MySQL "feature".

Another "mysql people" style answer.


We have only one engine: the full transactional one. If the OP need to have
for example the MEMORY one the he can easily create a RAM disk and with the
tablespaces support he can create tables or index or whatever objects
in memory.



Regards
Gaetano Mendola










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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: CVS web interface error
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Sketch of extending error handling for subtransactions