From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Thomas Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | "Lista PGSQL" <pgsql-general(at)postgresql(dot)org>, "Diego Schvartzman" <dschvar(at)yahoo(dot)com> |
Subject: | RE: CREATE USER |
Date: | 2000-06-01 05:58:49 |
Message-ID: | 000701bfcb8e$74fd11c0$2801007e@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
> Behalf Of Thomas Lockhart
>
> > I have to create users via an ODBC connection, but I get this error:
> > CREATE USER: may not be called in a transaction block
> > With psql I have no problems. Any body knows what is happening?
>
> Yeah. There are too many transaction block wrappers (BEGIN/COMMIT
> statements) in the ODBC driver. I'm not sure if we have patches for it
> yet...
>
Currently the following command sequence isn't allowed.
begin;
create user ...
commit;
This wouldn't be good for odbc/jdbc/ecpg etc.
How about starting new transaction automatically after committing
"create user ..." at backend side if "create user" is the first command
of the transaction ?
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Louis-David Mitterrand | 2000-06-01 06:17:12 | Re: [HACKERS] Oft Ask: How to contribute to PostgreSQL? |
Previous Message | Adam Walczykiewicz | 2000-06-01 05:45:48 | textpos() in postgreSQL 7.0 |