Re: Concurrent CREATE USER MAPPING and DROP SERVER

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ronan Dunklau <rdunklau(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Concurrent CREATE USER MAPPING and DROP SERVER
Date: 2013-07-04 15:03:30
Message-ID: 21564.1372950210@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Ronan Dunklau <rdunklau(at)gmail(dot)com> writes:
> It is possible to create a user mapping on a server and drop said server in
> two concurrent transactions, and have both succeed.

There are lots of hazards of this sort, since we generally don't try to
lock database objects other than tables when doing DDL. I can't get
particularly excited about this one compared to the rest. We could try
to extend the table-locking protocols to apply to all object types ...
but from here, the amount of work and complexity involved seems far out
of proportion to the benefit.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Noah Misch 2013-07-04 16:12:07 Re: windows 8 RTM compatibility issue (could not reserve shared memory region for child)
Previous Message Ronan Dunklau 2013-07-04 14:27:35 Concurrent CREATE USER MAPPING and DROP SERVER