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

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