Thanks Xavier - I'll make a note of that for the next time I'm forced to use MySQL :)
Anyone have any idea why that isn't the default though? 2010/1/27 Xavier Shay <[email protected]>: > > > 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. > > -- James -- 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.
