On 26/01/10 12:48 PM, James Sadler wrote:
The second big win is that Postgres doesn't silently truncate text
columns like MySQL does. Either a record inserts/updates entirely or
it doesn't at all. Postgres is simply more robust in this regard.
(and there may be options to enable this behaviour in MySQL, but they
are not enabled by default).
~> cat /etc/my.cnf
[mysqld]
sql-mode="STRICT_TRANS_TABLES"
Highly recommended. You can set it per connection if you want but this
doesn't seem like a good idea to me.
2010/1/26 Steve Hayes<[email protected]>:
Postgres has transactional DDL. Last time I looked MySQL didn't - that was
enough for me.
MySQL still doesn't
--
You received this message because you are subscribed to the Google Groups "Ruby or
Rails Oceania" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rails-oceania?hl=en.
