Re: [BUGS] Concurrent CREATE USER MAPPING and DROP SERVER

2013-07-04 Thread Tom Lane
Ronan Dunklau 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 p

[BUGS] Concurrent CREATE USER MAPPING and DROP SERVER

2013-07-04 Thread Ronan Dunklau
Hello. I think I may have found a bug in the CREATE USER MAPPING / DROP SERVER handling. It is possible to create a user mapping on a server and drop said server in two concurrent transactions, and have both succeed. This results in an orphan row in the pg_user_mapping table. I would expect o