Re: Transaction isolation and constraints - Mailing list pgsql-general

From Tom Lane
Subject Re: Transaction isolation and constraints
Date
Msg-id 11399.1196826397@sss.pgh.pa.us
Whole thread Raw
In response to Transaction isolation and constraints  (cliff@krumvieda.com)
Responses Re: Transaction isolation and constraints
List pgsql-general
cliff@krumvieda.com writes:
> suppose a table has a UNIQUE constraint on a column, and two
> concurrent transactions attempt to INSERT a row with the same value
> for that column:

Whichever one manages to get to the index page first will go through.
The second one will block waiting to see if the first one commits,
and will error out if so --- or proceed, if it aborts.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
Next
From: lighthouse.software@gmail.com
Date:
Subject: Re: ldap authentication allows logon with blank password