Thread: psql and jdbc insert discrepencies

psql and jdbc insert discrepencies

From
"Clyde Wright"
Date:
I've newly installed Postgres 7.3.3 on Redhat 6.0 and have a Java class
that inserts rows into a table NAME with attributes ID (serial) and
VALUE (text).

After running the program once and inserting a name, I get no errors.  I
then SELECT * FROM NAME; via JDBC and it returns the 1 row that has been
inserted.  However, when I do a SELECT * FROM NAME; from psql in Linux,
0 rows are returned.  When I do an insert from psql, the auto-id is 2
(as it should be) but still, upon querying the database via psql, only
the second row inserted is returned.

What I am missing here?

Cheers,
Clyde