WinZEOS components and CREATE USER

Поиск
Список
Период
Сортировка
От Alex Bolenok
Тема WinZEOS components and CREATE USER
Дата
Msg-id 000b01bfeca5$ee501d50$df02a8c0@artey.ru
обсуждение исходный текст
Список pgsql-general
Hello,

I use WinZEOS Delphi components. I want to create a user using ExecSQL
method of TZPgSqlQuery component. When I call this method, the exception is
raised: 'CREATE USER: may not be called in a transaction block'. The
component seems to begin an implicit BEGIN / END block when ExecSQL method
is called.
So the question is:

1. Is there any way to avoid calling of BEGIN / END in these components, or
2. Is there any way to create a user inside a transaction block? Direct
writes to pg_shadow don't work too, I have tried.

Thanks,

Alex Bolenok.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select for update not locking properly.
Следующее
От: Peter Mittermayer
Дата:
Сообщение: tcl/tk interface on Digital Unix