Skip site navigation (1) Skip section navigation (2)

Re: DDL in transactions?

From: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: DDL in transactions?
Date: 2005-03-31 17:24:03
Message-ID: 424C3233.9070109@eppesuigoccas.homedns.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka wrote:
[...]
>>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?

Thanks Kris, I am going to check it.

In response to

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2005-03-31 17:34:14
Subject: Re: DDL in transactions?
Previous:From: Kris JurkaDate: 2005-03-31 16:09:34
Subject: Re: DDL in transactions?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group