From: Greg Speegle <Greg@10happythings.com>
To: pgsql-interfaces@postgresql.org
Subject: JDBC Drop/Create problem?
Date: Thu, 07 Dec 2000 10:34:47 -0600
Message-ID: <3A2FBC27.5010207@10happythings.com> (raw)
References: <1B3D5E532D18D311861A00600865478CF1B633@exchange1.nt.maidstone.gov.uk>
Scenario:
Want to create a table via JDBC
Plan:
Drop existing table (if any)
Create new one
Problem:
If there was no table before, the Statement to drop the table throws an
exception, which is fine and not a problem.
However, if I then continue to try to create the table, I get a "table
not found" exception thrown by the Create
Statement. Doing a commit between the two eliminates the problem, but
this doesn't look like how the code
should work, or am I missing something?
Thanks for input,
Greg Speegle
BaylorUniversity
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Greg@10happythings.com
Subject: Re: JDBC Drop/Create problem?
In-Reply-To: <3A2FBC27.5010207@10happythings.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox