2009/8/27 Jaime Casanova <jcasanov@systemguards.com.ec>:
> 2009/8/27 Jean-Michel Pouré <jm@poure.com>:
>>
>> Otherwise, replicating some MySQL SQL syntax will not work.
>>
>> As you know, people willing to use PostgreSQL replication are possibly
>> already MySQL replication users. So if they test and PostgreSQL fails,
>> this is too bad.
>>
>
> yeah! but some times the reason MySQL is not failing on those cases is
> because it's broken...
> Consider this one:
> http://archives.postgresql.org/pgsql-general/2005-12/msg00487.php
>
> we don't want to copy the bugs nor the bad designs decisions from
> MySQL, no that everything from MySQL is bad but i would be scary if we
> start supporting every single piece of code MySQL accepts
>
And that behavior has changed to be sane in 5.0+, iirc.
--
Rob Wultsch
wultsch@gmail.com