From: dvarrazzo (@dvarrazzo) <noreply+dvarrazzo@github.com>
To: psycopg/psycopg <noreply+psycopg-psycopg@github.com>
Subject: Re: [psycopg/psycopg] issue #1040: Oddity with ltree + query in binary mode
Date: Thu, 25 Sep 2025 22:29:18 +0000
Message-ID: <gh-psycopg-psycopg-1040-c3336127768@github.com> (raw)
In-Reply-To: <gh-psycopg-psycopg-1040@github.com>
References: <gh-psycopg-psycopg-1040@github.com>
Hello,
FYI, I have dumped the state of the Ltree module working with Psycopg 3 in the [pg3 branch](https://github.com/dvarrazzo/py-ltree/commits/pg3) of the py-ltree project. The readme has [Psycopg 3 usage notes](https://github.com/dvarrazzo/py-ltree/tree/pg3?tab=readme-ov-file#using-with-psycopg-3). I have also added support for binary dump/load.
This is not production ready as it is, it needs Postgres tests. In a conversation with a friend the topic cropped up and I realized I never published this bit of work. So I'm pushing it out for testing.
I am not sure yet if this is the good design candidate to be included in Psycopg, but if you want to do some tests with it and report your findings it would be very useful.