Sequences and jdbc 6.3.2 (fwd)

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: PostgreSQL Hackers List <hackers(at)postgresql(dot)org>
Subject: Sequences and jdbc 6.3.2 (fwd)
Date: 1998-10-13 05:51:39
Message-ID: Pine.LNX.3.96.981013065015.30249D-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've just had this sent to me.

In this case, the correct method that should have been used (in JDBC) is
stmnt.executeUpdate(), but the fact that he couldn't remove the sequence
is worrying.

Was this an old problem now fixed?

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

---------- Forwarded message ----------
Date: Mon, 12 Oct 1998 21:25:21 -0700
From: Jason Venner <jason(at)idiom(dot)com>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Subject: Sequences and jdbc 6.3.2

I have an interesting problem.
I would like to create sequences via the jdbc interface. The problem
is that if I try to create a sequence via jdbc

Statement stmnt = connection.createStatement();
stmnt.execute( "create sequence image_seq start 50" );

The creation failes
execute returns false and
the postmaster spits out
ERROR: cannot create image_seq

Then, forever after, even by psql, I can't create or drop that
sequence name.
I have to destroy the database.

Browse pgsql-hackers by date

  From Date Subject
Next Message Billy G. Allie 1998-10-13 06:03:09 Re: [HACKERS] dynamic libraries
Previous Message brian 1998-10-13 03:18:13 Re: pgsql-interfaces-digest V1 #105