Re: UUID v7

2024-11-23 Thread Andrey M. Borodin
> On 23 Nov 2024, at 10:58, Masahiko Sawada wrote: > > I've attached an updated patch that squashed changes I made for v33. > We're still discussing increasing entropy on Windows and macOS, but > the patch seems to be in good shape. +1, thanks! PFA version with improved comment. Sergey Prokh

Re: Document NULL

2024-11-23 Thread Marcos Pegoraro
Em qui., 21 de nov. de 2024 às 12:04, David G. Johnston < david.g.johns...@gmail.com> escreveu: Typo in NuLl, mixed upper and lower case. SELECT NULL AS "Literal Null Value", pg_typeof(null) AS "Type of Null", pg_typeof(NuLl::text) AS "Type of Cast null", cast(null as text) AS "Ca

Use or not record count on examples

2024-11-23 Thread Marcos Pegoraro
There is no rule of when the number of records at the end of the lists should be shown or not Sometimes we show that line "(4 rows)", but sometimes not. Should we have a standard for it ? Should we add them all or remove them all ? I think they are useless. Or maybe shown when no rows are returned.

Re: [BUG?] check_exclusion_or_unique_constraint false negative

2024-11-23 Thread Michail Nikolaev
Hello, everyone! A rebased version is attached. Also, fixed potential race in the test and detailed commit messages. Best regards, Mikhail. > v3-0001-Fix-possible-lost-tuples-in-non-MVCC-index-scans-.patch Description: Binary data v3-0002-Add-isolation-test-to-reproduce-dirty-snapshot-sc.pat

Re: Replace current implementations in crypt() and gen_salt() to OpenSSL

2024-11-23 Thread Joe Conway
On 11/22/24 09:11, Daniel Gustafsson wrote: On 21 Nov 2024, at 22:39, Joe Conway wrote: I mean, perhaps I am misreading and/or interpreting all of that differently to you, but from my reading of the entire thread there was clearly no consensus to using openssl to provide those two functions

Re: Forbid to DROP temp tables of other sessions

2024-11-23 Thread Andrey M. Borodin
> On 22 Nov 2024, at 03:02, Andres Freund wrote: > > I don't > love having to put RELATION_IS_OTHER_TEMP() checks everywhere either. +1. I do not understand why this restriction (protecting temp tables from access) is a responsibility of the buffer manager. Actually, I like the idea that su