On Wed, Jul 23, 2008 at 10:22 PM, Artacus <artacus@comcast.net> 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.