Received: from waco2.calpha.com (waco2.calpha.com [208.232.233.3])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB7GYUP75947
	for <pgsql-interfaces@postgresql.org>;
	Thu, 7 Dec 2000 11:34:30 -0500 (EST)
	(envelope-from Greg@10happythings.com)
Received: from 10happythings.com (gspeegle.t1-s.wireless.calpha.com
	[63.80.26.25] (may be forged))
	by waco2.calpha.com (8.10.1/8.10.1) with ESMTP id eB7GYkV13784
	for <pgsql-interfaces@postgresql.org>; Thu, 7 Dec 2000 10:34:47 -0600
Message-ID: <3A2FBC27.5010207@10happythings.com>
Date: Thu, 07 Dec 2000 10:34:47 -0600
From: Greg Speegle <Greg@10happythings.com>
User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US;
	m18) Gecko/20001108 Netscape6/6.0
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC Drop/Create problem?
References: 
 <1B3D5E532D18D311861A00600865478CF1B633@exchange1.nt.maidstone.gov.uk>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200012/52
X-Sequence-Number: 389


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