Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-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

pgsql-novice by date

Next:From: Wolfgang DrotschmannDate: 2003-07-24 05:57:19
Subject: Re: CREATE TYPE with array
Previous:From: Barry LindDate: 2003-07-24 02:18:15
Subject: Re: psql and jdbc insert discrepencies

pgsql-jdbc by date

Next:From: Tom LaneDate: 2003-07-24 02:19:10
Subject: Re: New builds posted to jdbc.postgresql.org websit for jdbc driver
Previous:From: Barry LindDate: 2003-07-24 02:18:15
Subject: Re: psql and jdbc insert discrepencies

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group