| 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: | Whole Thread | Raw Message | 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
| 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 |