From: | Jason Dusek <jason(dot)dusek(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SERIALIZABLE and INSERTs with multiple VALUES |
Date: | 2016-10-11 20:13:31 |
Message-ID: | CAO3NbwOuu43+qBv45qnxeur=mEyjmJUVH18R04OsfRLpezTNAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SELECT version(),
(SELECT setting FROM pg_settings WHERE name =
'default_transaction_deferrable') AS default_transaction_deferrable,
(SELECT setting FROM pg_settings WHERE name =
'default_transaction_isolation') AS default_transaction_isolation;
─[ RECORD 1 ]──────────────────┬─────────────────────────────────────────────────────────────────────────────────────────────────────────────
version │ PostgreSQL 9.5.4 on
x86_64-apple-darwin15.6.0, compiled by Apple LLVM version 8.0.0
(clang-800.0.38), 64-bit
default_transaction_deferrable │ on
default_transaction_isolation │ serializable
On Tue, 11 Oct 2016 at 13:00 Kevin Grittner <kgrittn(at)gmail(dot)com> wrote:
> On Tue, Oct 11, 2016 at 2:29 PM, Jason Dusek <jason(dot)dusek(at)gmail(dot)com>
> wrote:
>
> > I notice the following oddity:
>
> > =# CREATE TABLE with_pk (i integer PRIMARY KEY);
> > CREATE TABLE
>
> > =# BEGIN;
> > BEGIN
> > =# INSERT INTO with_pk VALUES (2), (2) ON CONFLICT DO NOTHING;
> > ERROR: could not serialize access due to concurrent update
> > =# END;
> > ROLLBACK
>
> I don't see that on development HEAD. What version are you
> running? What is your setting for default_transaction_isolation?
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-10-11 23:15:55 | Re: LOG: munmap(0x7fff80000000) failed: Invalid argument |
Previous Message | Chris Richards | 2016-10-11 20:06:19 | Re: LOG: munmap(0x7fff80000000) failed: Invalid argument |