Kris Jurka schrieb:
>>My question is: why? Shouldn't DDL be executed immediately?
> No. DDL in postgresql is fully transactable and may be rolled back or
> committed. That doesn't explain why the above code doesn't work.
> Because the two executeUpdates are on the same Statement on the same
> Connection the second execution should see the newly created table because
> it is in the same transaction. Perhaps you are not showing us the real
> code you are using and you actually have two connections?
You can simply try this out via psql:
lwgeom=# create table tester (a int);
lwgeom=# insert into tester values (1);
INSERT 281855490 1
lwgeom=# select * from tester;
ERROR: relation "tester" does not exist
In response to
pgsql-jdbc by date
|Next:||From: Nico||Date: 2005-04-01 01:16:46|
|Subject: only postgresqsl in connection pool|
|Previous:||From: Giuseppe Sacco||Date: 2005-03-31 17:24:03|
|Subject: Re: DDL in transactions?|