Re: how to use query_tree_walker to get all relations used in a query

Hi, On Sat, Aug 19, 2023 at 03:26:06PM +0200, Pierre Forstmann wrote: > > I am trying to get the list of all relations used in a SELECT query using > the post parse analyze hook. > > I can get all relations from top level FROM clause but I cannot get them > for a simple subquery like: > > select

Re: PG minor version in data directory?

On 2023-08-19 19:14, Peter J. Holzer wrote: On 2023-08-19 14:22:25 +1000, Justin Clift wrote: Thanks, that's what I figured. I'll have to keep state in a PG_VERSION_MINOR there or something. :) Wouldn't it be better to ask whatever system you use to install the software for the version?

Re: case and accent insensitive search under Python ?

M4X <77...@gmx.com> writes: > It seem that is possible to make a search that is case and accent > insensitive. > |I've dig https://www.postgresql.org/docs/current/textsearch-intro.html > and other resources,| > |but I didn't find yet an example that demonstrate it. The text search functionality

how to use query_tree_walker to get all relations used in a query

Hello, I am trying to get the list of all relations used in a SELECT query using the post parse analyze hook. I can get all relations from top level FROM clause but I cannot get them for a simple subquery like: select * from t1 where x1=(select max(x2) from t2); My current code is: static

Re: Failing to compile with ICU support error on Ubuntu

Thanks for the reference. A good place to go for any build related errors. - Siddharth On Sat, Aug 19, 2023 at 5:46 PM Erik Wienhold wrote: > > On 19/08/2023 14:03 CEST Siddharth Karandikar < > siddharth.karandi...@gmail.com> wrote: > > > > Thanks a lot Erik. It worked. > > Not sure if the

Re: Failing to compile with ICU support error on Ubuntu

> On 19/08/2023 14:03 CEST Siddharth Karandikar > wrote: > > Thanks a lot Erik. It worked. > Not sure if the build script gave any specific error about this or I just > missed that... :) No, the output of ./configure only says "not found" without giving the exact reason. The docs have details

Re: Failing to compile with ICU support error on Ubuntu

Thanks a lot Erik. It worked. Not sure if the build script gave any specific error about this or I just missed that... :) On Sat, Aug 19, 2023 at 5:17 PM Erik Wienhold wrote: > > On 19/08/2023 13:26 CEST Siddharth Karandikar < > siddharth.karandi...@gmail.com> wrote: > > > > I am trying to

Re: Failing to compile with ICU support error on Ubuntu

> On 19/08/2023 13:26 CEST Siddharth Karandikar > wrote: > > I am trying to build the latest postgresql on my ubuntu docker instance. > But its failing to compile it even when ICU related libraries are installed. > > Compilation fails with > ``` > checking whether to build with ICU support...

Failing to compile with ICU support error on Ubuntu

Hi, I am trying to build the latest postgresql on my ubuntu docker instance. But its failing to compile it even when ICU related libraries are installed. Compilation fails with ``` checking whether to build with ICU support... yes checking for icu-uc icu-i18n... no configure: error: ICU library

Re: PG minor version in data directory?

On 2023-08-19 14:22:25 +1000, Justin Clift wrote: > On 2023-08-19 14:10, David G. Johnston wrote: > > On Fri, Aug 18, 2023 at 6:36 PM Justin Clift > > wrote: > > > > > If the minor version is already tracked somewhere as well, that > > > would be extremely useful for my use case. > > > > > > >

case and accent insensitive search under Python ?

Hi, I'm considering to migrate to postgresql... ( still examining the pro/con ) It seem that is possible to make a search that is case and accent insensitive. |I've dig https://www.postgresql.org/docs/current/textsearch-intro.html and other resources,| |but I didn't find yet an example that