From: | "Chris White" <cjwhite(at)cisco(dot)com> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Programmatically dropping and creating table |
Date: | 2002-10-03 22:08:17 |
Message-ID: | 00ad01c26b29$612374e0$ff926b80@amer.cisco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
It gives me PostgresSQL 7.2.1.
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, October 03, 2002 3:04 PM
To: cjwhite(at)cisco(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Programmatically dropping and creating table
"Chris White" <cjwhite(at)cisco(dot)com> writes:
> I am running Postgresql 7.2 and programmatically trying to drop a table
> called vm_config and then recreate it from java. The drop seems to work,
but
> when I try to recreate the table I get a SQL exception saying "ERROR:
cannot
> create vm_config: file exists". If I do a commit after the drop and then
do
> the create I get the SQL Exception "ERROR: cannot create vm_config_pkey:
> file exists". What am I doing wrong?
Are you *certain* you are talking to a 7.2 backend? That sounds a whole
lot like the behavior you'd get back around 7.0 or earlier, before we'd
switched to OID-based filenames: drop/create table inside a transaction
didn't really work because of filename conflicts. Try "select
version()" to be sure what you're talking to.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-10-03 22:18:36 | Re: Programmatically dropping and creating table |
Previous Message | Tom Lane | 2002-10-03 22:03:55 | Re: Programmatically dropping and creating table |