Re: storage engine , mysql syntax CREATE TABLE t (i INT) - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: storage engine , mysql syntax CREATE TABLE t (i INT)
Date
Msg-id 410434AB.8090205@pse-consulting.de
Whole thread Raw
In response to storage engine , mysql syntax CREATE TABLE t (i INT) ENGINE = INNODB|BDB  (Pierre Emmanuel Gros <Pierre-Emmanuel.Gros@limsi.fr>)
Responses Re: storage engine , mysql syntax CREATE TABLE t (i INT)  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
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.
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".

Regards,
Andreas


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: PITR Backup state validity checking
Next
From: Bruce Momjian
Date:
Subject: Re: storage engine , mysql syntax CREATE TABLE t (i INT) ENGINE