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

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Pierre Emmanuel Gros <Pierre-Emmanuel(dot)Gros(at)limsi(dot)fr>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: storage engine , mysql syntax CREATE TABLE t (i INT)
Date: 2004-07-25 22:31:07
Message-ID: 410434AB.8090205@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-07-25 23:55:50 Re: [HACKERS] 7.5 release notes
Previous Message Peter Eisentraut 2004-07-25 22:25:19 Re: storage engine , mysql syntax CREATE TABLE t (i INT)