On Wed, Jul 23, 2008 at 10:22 PM, Artacus <artacus@xxxxxxxxxxx> wrote: >> This is one of the many SQL bad habits you've likely picked up from >> using MySQL. I'd highly suggest reading the pgsql users manual cover >> to cover, you'll pick up a lot of good info on how to drive >> postgresql. Other things that work in mysql but fail in pgsql include >> inserting things that are out of range. > > You know, I bet as many of us came to PostgreSQL from a MySQL background as > from Oracle. It might be good to have a section in the manual for how to > transition from using the "tricks" in MySQL to a strict environment like > Postgres. And one for Oracle as well. I've seen a few people show up wondering how postgresql handles running out of rollback space... ahem.
