Horton

Re: [PATCH] ltree, lquery, and ltxtquery binary protocol support

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nino Floris <mail@ninofloris.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>, Michael Paquier <michael@paquier.xyz>, Alvaro Herrera <alvherre@2ndquadrant.com>, Alexander Korotkov <a.korotkov@postgrespro.ru>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-03-06T17:40:45Z
Lists: pgsql-hackers 
Nino Floris <mail@ninofloris.com> writes:
> Attached is the new patch rebased onto master.

The approach of simply providing a 1.2 installation script, with no
upgrade path from 1.1, is surely not going to be acceptable to anyone
who's using ltree in production.

Fortunately for the odds of getting this patch accepted, we just
pushed an ALTER TYPE improvement that will solve your problem [1].
Please replace ltree--1.2.sql with an upgrade script that uses
that, and resubmit.

			regards, tom lane

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=fe30e7ebfa3846416f1adeb7cf611006513a4ee0

Commits

  1. Add support for binary I/O of ltree, lquery, and ltxtquery types.

  2. Allow ALTER TYPE to change some properties of a base type.