Re: Race condition in create table

2018-10-09 Thread Tom Lane
Konstantin Knizhnik writes: > I wonder if it is considered to be expected behavior that concurrent > execution of "create table if not exists" may return errors: No, there's not a guarantee that IF NOT EXISTS will work in such scenarios. As with everything else about that feature, it's a quick-

Race condition in create table

2018-10-09 Thread Konstantin Knizhnik
I wonder if it is considered to be expected behavior that concurrent execution of "create table if not exists" may return errors: knizhnik@knizhnik:~/dtm-data$ pgbench -n -c 8 -t 20 -f create_table.sql postgres client 2 aborted in command 0 (SQL) of script 0; ERROR:  duplicate key value violat