Hi Folks,
I am a fan of pgsql and have been using it for lots personal projects where
stability of PgSQL was not an issue and most of the time the machine was
close to me, so that I could restart the daemons whenever there was a
problem. However, now I am writing an ERP solution and am thinking of using
EJB along with Postgresql. What I am concerned about is the reliability and
stability of Postgresql and it's JDBC driver. Is anybody using Postgresql
and JDBC in a "production" environment? Has anybody faced any wierd
problems? For example, when I was using the tool TableGen (generates java
code from database table), I found out that some of it was not working
because PgSQL's JDBC driver didn't support getImportedKeys() and
getExportedKeys(). Now are there any such issues? I wouldn't like to hear
sometime later that, for example, there is no support for BLOBs as well.
Any personal experiences will be greatly appreciated.
Thanks for your time.
-ngd.
