Re: Serializable Transaction Anomoly

2024-11-05 Thread Daniel Bickler
You are correct, that is where I made the mistake. Thank you for the clarification; I understand much better now and the behavior we experienced makes sense with the correct reading of the documentation. Daniel Bickler From: Laurenz Albe Date: Tuesday, November 5, 2024 at 2:17 PM To: Daniel Bic

Re: Serializable Transaction Anomoly

2024-11-05 Thread Daniel Bickler
Thank you for the prompt response, I’m probably misreading the documentation and how it relates to the example we ran into. The way I interpreted the documentation, the example I ran into was a false negative according to the definition of a serialization anomaly, because it’s serial in one ord

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-11-05 Thread David Rowley
On Wed, 30 Oct 2024 at 11:39, Daniel Gustafsson wrote: > > > On 29 Oct 2024, at 23:36, David Rowley wrote: > > Do you have access to make this change? I think it needs to go into > > https://www.postgresql.org/media/css/main.css > > I have a pgweb commitbit so if you roll a patch for it I can ta

Re: Serializable Transaction Anomoly

2024-11-05 Thread Laurenz Albe
On Tue, 2024-11-05 at 18:41 +, Daniel Bickler wrote: > The way I interpreted the documentation, the example I ran into was a false > negative > according to the definition of a serialization anomaly, because it’s serial > in one > ordering but not the other which seems incorrect with “all pos

Re: Serializable Transaction Anomoly

2024-11-05 Thread Laurenz Albe
On Tue, 2024-11-05 at 15:05 +, PG Doc comments form wrote: > I discovered an oddity in Serializable Transaction behavior and while > referencing the current docs there is a possible contradiction and I'm not > sure if this is a bug or expected behavior. At minimum there seems to be a > contradi

Serializable Transaction Anomoly

2024-11-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/transaction-iso.html Description: I discovered an oddity in Serializable Transaction behavior and while referencing the current docs there is a possible contradiction and I'm not sure if t

Re: https://www.postgresql.org/docs/current/sql-insert.html

2024-11-05 Thread David G. Johnston
On Saturday, November 2, 2024, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/sql-insert.html > Description: > > Is my suspicion valid? > The presence of the returning clause and subsequent usage of t

https://www.postgresql.org/docs/current/sql-insert.html

2024-11-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-insert.html Description: Hi, the example found in the doc above: WITH upd AS ( UPDATE employees SET sales_count = sales_count + 1 WHERE id = (SELECT sales_person FROM accounts W

Parallel index build for BRIN

2024-11-05 Thread Egor Rogov
Hi, Commit b4375717 introduced parallel CREATE INDEX for BRIN. I've noticed that a couple of documentation pages need to be updated accordingly. A small patch is attached. Thanks, Egor From 50dd542f113b915d52f47347efb6d7835bc6bb40 Mon Sep 17 00:00:00 2001 From: Egor Rogov Date: Tue, 5 Nov 20