| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Jesus Aneiros <aneiros(at)ucfinfo(dot)ucf(dot)edu(dot)cu> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CREATE USER |
| Date: | 2001-04-30 09:01:05 |
| Message-ID: | Pine.LNX.4.30.0104301058190.900-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Einar Karttunen | 2001-04-30 09:14:46 | Performance of c, pl/perl, pl/pgsql |
| Previous Message | Jesus Aneiros | 2001-04-30 07:05:56 | CREATE USER |