Re: DDL in transactions? - Mailing list pgsql-jdbc

From Giuseppe Sacco
Subject Re: DDL in transactions?
Date
Msg-id 1112339594.3809.14.camel@localhost
Whole thread Raw
In response to Re: DDL in transactions?  (Kris Jurka <books@ejurka.com>)
Responses Re: DDL in transactions?
List pgsql-jdbc
Il giorno gio, 31-03-2005 alle 11:09 -0500, Kris Jurka ha scritto:
[...]
> > 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?

Hi Kris,
you was right: I used two different connections.

BTW, is it possible to disable this behaviour and have DDL statement
immediately executed?

Thanks,
Giuseppe


pgsql-jdbc by date:

Previous
From: "Nico"
Date:
Subject: only postgresqsl in connection pool
Next
From: Kris Jurka
Date:
Subject: Re: DDL in transactions?