Re: CREATE USER - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: CREATE USER
Date
Msg-id Pine.LNX.4.30.0104301058190.900-100000@peter.localdomain
Whole thread Raw
In response to CREATE USER  (Jesus Aneiros <aneiros@ucfinfo.ucf.edu.cu>)
List pgsql-general
Jesus Aneiros writes:

> Perhaps this is a stupid question but I wonder why I could not put a
> CREATE USER inside a transaction block?

Because CREATE USER may have to update a flat-text file.  If you roll back
the surrounding transaction the changes to the flat-text file will not be
reverted and you may get weird authentication failures.  This system is
admittedly a bit silly but the alternatives look like too much work for
little benefit.  I think in 7.1 you can run CREATE USER in transaction
blocks, you just have to be careful.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Jesus Aneiros
Date:
Subject: CREATE USER
Next
From: Einar Karttunen
Date:
Subject: Performance of c, pl/perl, pl/pgsql