From: | "Clyde Wright" <clyde-wright(at)utulsa(dot)edu> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | psql and jdbc insert discrepencies |
Date: | 2003-07-24 02:18:36 |
Message-ID: | 000701c35189$e3dbd430$72d95582@SALO |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-24 02:19:10 | Re: New builds posted to jdbc.postgresql.org websit for jdbc driver |
Previous Message | Barry Lind | 2003-07-24 02:18:15 | Re: psql and jdbc insert discrepencies |
From | Date | Subject | |
---|---|---|---|
Next Message | Wolfgang Drotschmann | 2003-07-24 05:57:19 | Re: CREATE TYPE with array |
Previous Message | Barry Lind | 2003-07-24 02:18:15 | Re: psql and jdbc insert discrepencies |