Re: SQL compatibility reminder: MySQL vs PostgreSQL - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: SQL compatibility reminder: MySQL vs PostgreSQL
Date
Msg-id 4B92C292.5020605@dunslane.net
Whole thread Raw
In response to Re: SQL compatibility reminder: MySQL vs PostgreSQL  (François Pérou <francois.perou@free.fr>)
Responses Re: SQL compatibility reminder: MySQL vs PostgreSQL
List pgsql-hackers

François Pérou wrote:
>
> My opinion is that PostgreSQL should accept any MySQL syntax and return
> warnings. I believe that we should access even innodb syntax and turn it
> immediately into PostgreSQL tables. This would allow people with no
> interest in SQL to migrate from MySQL to PostgreSQL without any harm.
>   

This is just fantasy. Doing this will destabilize Postgres, cost us 
hugely in maintenance effort and LOSE us users.

If we do this why the heck should we stop there? Why shouldn't we 
replicate the broken behaviour of every major database out there?

It's really time for you to stop making this suggestion, once and for 
all. It is just not going to happen. Moreover MySQL appears to be 
fracturing into a bunch of different forks, so why now, of all times, 
would we want to adopt its broken syntax?

cheers

andrew




pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Using GIN/Gist to search the "union" of two indexes?
Next
From: Tom Lane
Date:
Subject: Re: Explicit psqlrc