RE: CREATE USER

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
> > How about starting new transaction automatically after committing
> > "create user ..." at backend side if "create user" is the first command
> > of the transaction ?
>
> So then
> begin;
> create user ...;
> rollback;
>
> would do the wrong thing --- silently?
>

It seems not wrong that un-rollbackable command is never rolled back.
At least it doesn't cause inconsistency.

> I don't think that's an improvement :-(
>
> The only reason CREATE USER isn't rollbackable is that the flat password
> file is updated immediately by a trigger, rather than at transaction
> commit. The right fix would be to defer the update until commit (which
> is certainly doable, though it might mean hardwired support for the
> update instead of doing it in a generic trigger function).
>
> If that seems like too much work,

I don't prefer flat file solution as I mentioned before.

> how about downgrading the "create
> user not allowed in transaction" error to a "please don't abort now"
> notice?

Sounds preferable.

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp