BUG #11088: posgres blocks when i don't commit

From: guido(at)sofer(dot)com(dot)ar
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11088: posgres blocks when i don't commit
Date: 2014-07-29 17:14:23
Message-ID: 20140729171423.16602.76857@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11088
Logged by: Guido
Email address: guido(at)sofer(dot)com(dot)ar
PostgreSQL version: 9.3.5
Operating system: Linux
Description:

Hi, I encountered the next problem, i really don't know how to describe it
in one sentence:

I have one table 'TABLE' with a column 'COLUMN' and 'COLUMN' is a primary
key

I have two processes 'proc1' and 'proc2'

proc1 inserts a row in 'TABLE' with 'A' in the column 'COLUMN'...
AND IT DOESNT COMMIT

proc2 tries to insert a row with 'A' in the column 'COLUMN'

What happens is that posgres simply don't respond (not an error, nothing
happens)

Is that normal? maybe yes, if it is, sorry for taking your time...

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message brorfred 2014-07-29 17:40:23 BUG #11090: Unclear error message in pg_upgrade
Previous Message Tom Lane 2014-07-29 15:50:41 Re: BUG #11078: this query crash on array_agg, but there is no array_agg