Postgres Pro
Downloads
Home   >   mailing lists

Re: using index or check in ALTER TABLE SET NOT NULL - Mailing list pgsql-hackers

From Andres Freund
Subject Re: using index or check in ALTER TABLE SET NOT NULL
Date
Msg-id 900056D1-32DF-4927-8251-3E0C0DC407FD@anarazel.de
Whole thread Raw
In response to Re: using index or check in ALTER TABLE SET NOT NULL  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 

On November 29, 2017 8:50:31 AM PST, Stephen Frost <sfrost@snowman.net> wrote:
>As for conflicting snapshots, isn't the lock we're taking already
>AccessExclusive..?

Doesn't help if e.g. the current xact is repeatable read or if your own xact deleted things (other xacts with snapshots
couldstill see null rows, despite new take definition).  

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

pgsql-hackers by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: using index or check in ALTER TABLE SET NOT NULL
Next
From: Shubham Barai
Date:
Subject: Re: [HACKERS] GSoC 2017 : Patch for predicate locking in Gist index