How to get rid of NOTICE:

From: szilva(at)computer(dot)org
To: pgsql-jdbc(at)postgresql(dot)org
Subject: How to get rid of NOTICE:
Date: 2003-09-19 16:57:29
Message-ID: Pine.LNX.4.58.0309191848250.4525@collapsed.wormhole.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dear All,

Using pg 7.3.4, Sun jvm 1.4.1_02 and either pg73jdbc3.jar or
pg73jdbc2.jar on Linux Debian Woody I experiencing some problems when
creating a table via JDBC.

This statement: CREATE TABLE testtable(
cd_id serial NOT NULL PRIMARY KEY,
cd_structure BYTEA NOT NULL,
cd_smiles VARCHAR(1000) NULL,
cd_formula VARCHAR(100) NULL,
cd_molweight float8 NULL,
cd_fp1 int4 NOT NULL
);

works fine from rsql, but using JDBC I will have an error:

java.sql.SQLException: ERROR: current transaction is aborted, queries
ignored until end of transaction block
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)

As far as I can see, it is because when creating the table a NOTICE will
be printed like:

NOTICE: CREATE TABLE will create implicit sequence 'asdasd_cd_id_seq' for
SERIAL column 'asdasd.cd_id'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'asdasd_pkey' for table 'asdasd'

that is interpreted as an exception in JDBC. Is there a way to get rid of
this?

Cheers:
Szilva

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-09-19 17:05:14 Re: How to get rid of NOTICE:
Previous Message Xavier Poinsard 2003-09-19 15:31:10 Parse problem in AbstractJdbc2ResultSet.parseQuery