I have worked with PostgreSQL. The first problem I ran into was that Postgres has an arcane limit of 8k of data per row. The other - its "serial" data type (the equivalent of MySQL's auto_increment) creates a "sequence" which does not get dropped when its parent table is dropped. So if you try to re-create the table, you'll get a name conflict for this sequence. A lot of new users would be confused by this, so Postgres loses a couple points for that.Postgres' sequence (auto_increment value) does not get reset when you import data, causing all new inserts to fail.
I managed to get Postgresql installed and running on my RedHat6.2 machine. I want to connect to it using servlets from my Win98 machine running Tomcat. What I have done is to place a copy of the jdbc6.5-1.2.jar file in the Win98 machine and set the classpath to point to it. Start the servlet to make the connection. However I got a SQL exception message from Tomcat saying:- can't find class for driver: org.postgresql.Driver..... I am very sure the classpath was set correctly. I got the same message when I tried to connect to the database in the RedHat6.2 machine (also using servlet and running Tomcat). Any pointers?
Joined: Dec 11, 2000
Just to add... I have actually managed to connect to Postgresql a couple of months back using the same technique described above. I have not touched it for a couple of months and somehow it does not work now.