Forum OpenACS Q&A: Response to If money grew on trees, which would you choose Oracle or PG?

Some thoughts on living with the two as a developer: I've used Oracle more than Postgres at this point, and I've always found tracking down syntax errors in functions or queries to be a lot easier with Oracle. Postgres error messages are just not specific enough. And while pl/pgsql is good enough to be worth using, PL/SQL is clearly more refined at this stage in the game. Also, there's lots of decent documentation for Oracle. This becomes less of an issue if you work with Postgres a lot, I suppose, but Oracle has proven more user (er, programmer) friendly for me. Postgres seems to be improving so quickly though, who knows...

Roberto's right about sql plus: it's awful.