WinZEOS components and CREATE USER

From: "Alex Bolenok" <abolen(at)chat(dot)ru>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: WinZEOS components and CREATE USER
Date: 2000-07-13 08:39:43
Message-ID: 000b01bfeca5$ee501d50$df02a8c0@artey.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Peter Mittermayer 2000-07-13 08:46:30 tcl/tk interface on Digital Unix
Previous Message Hannu Krosing 2000-07-13 07:39:36 Re: lztext and compression ratios...