| 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: | Whole Thread | Raw Message | 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 |