Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE

2024-11-28 Thread Bertrand Mamasam
On Thu, Nov 28, 2024 at 11:35 PM Tom Lane wrote: > I wrote: > > Thanks for the test case! A quick "git bisect" says I broke it at > > cb8e50a4a09fe541e32cd54ea90a97f2924121a1 is the first bad commit > > commit cb8e50a4a09fe541e32cd54ea90a97f2924121a1 > > Author: Tom Lane > > Date: Fri Aug 30

Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE

2024-11-28 Thread Bertrand Mamasam
On Thu, Nov 28, 2024 at 5:15 PM Tom Lane wrote: > Bertrand Mamasam writes: > > I get this error in PG16.5, 16.6 and 17 : > > wrong varnullingrels (b 3) (expected (b)) for Var 1/19 > > Please provide a self-contained test case. A fragmentary query > with no underlyi

ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE

2024-11-28 Thread Bertrand Mamasam
Hello, My query has been working fine in 16.4 and before, but not anymore in 16.5, 16.6 and 17. It is a query with multiple CTE, some of which are using values of the previous ones, and the end of the query sort of make a mix of found values with aggregation from a LATERAL JOIN. Something like thi

Re: pg_trgm vs. Solr ngram

2023-02-09 Thread Bertrand Mamasam
Le ven. 10 févr. 2023, 03:20, Chris a écrit : > Hello list > > I'm pondering migrating an FTS application from Solr to Postgres, just > because we use Postgres for everything else. > > The application is basically fgrep with a web frontend. However the > indexed documents are very computer networ

Re: Primary keys and composite unique keys(basic question)

2021-04-02 Thread Bertrand Mamasam
On Fri, Apr 2, 2021 at 8:57 AM Hemil Ruparel wrote: > I used uuid4 for customer ids because i needed to interface with payment > providers. Is that wrong? All other places except transaction ids, i have > used serial ints > > On Fri 2 Apr, 2021, 8:56 AM Rob Sargent, wrote: > >> On 4/1/21 8:28 PM