On 2/23/07, Tomas Vondra <tv@xxxxxxxx> wrote:
Sure, there are many differences when it comes to internals (Albe Laurenz already pointed out the most obvious one), as well as the Oracle is superior in many areas (partitioning, some features in PL/SQL, etc.). This generally means that if you have an application architecture for PostgreSQL, then it will usually work fine Oracle. If the constraint is correctly enforced in PostgreSQL, then it will be enforced in Oracle etc.
be careful with that statement....some of the internals are better and some are worse. all postgresql ddl is transactional for example. how easily the code ports is going to depend on how tweaky the developers were...it's very easy to fall in love with postgresql-specific features and write unportable code. merlin
