psql and jdbc insert discrepencies

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

Responses

Browse pgsql-jdbc by date

  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

Browse pgsql-novice by date

  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