Re: DDL in transactions?

Поиск
Список
Период
Сортировка
От Giuseppe Sacco
Тема Re: DDL in transactions?
Дата
Msg-id 424C3233.9070109@eppesuigoccas.homedns.org
обсуждение исходный текст
Ответ на Re: DDL in transactions?  (Kris Jurka <books@ejurka.com>)
Список 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.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: DDL in transactions?
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: DDL in transactions?