I recently ported a small Oracle web application to PostgreSQL.
Using Apache, Red Hat 6.2 and JDK1.2.2.
The database only used tables, views, and sequences, so it's a pretty small
test case, and the conversion went without much difficulty. The only issues
were:
1.
In my Oracle app I was updating the views.
Can't do that in PostgreSQL.
No problem though, I just edited the table directly.
2.
Oracle has some nice text formating and date conversion functions which are not
in PostgreSQL.
I'm just living without them until I write some replacement functions.
3.
PostgreSQL Documentation is still not finished.
Don't stray to far, you will find yourself all on your own.
All in all. I am happy with PostgreSQL. Looking forward to seeing it mature a
little bit. Once that happens, I expect it to shake up the industry a bit.
Much like Linux is doing now.
Rick
