Re: contrib/cube - binary input/output handlers

2021年3月3日(水) 23:33 Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>:
>
> On 24.02.21 04:18, Kohei KaiGai wrote:
> > This patch adds cube_send / cube_recv handlers on the contrib/cube data type.
> > Once this patch was applied to, the libpq client can obtain the table
> > data using binary mode.
>
> Seems reasonable. But you need to write an extension upgrade script and
> bump the extension version.
>
Thanks for your review.

One thing not straightforward is that a new definition of cube type
needs to drop
the old definition once, then it leads cascaded deletion to the
objects that depends
on the "cube" type declared at the cube--1.2.sql.
Do you have any good ideas?

Idea-1) modify system catalog by UPDATE pg_type carefully.
It can avoid cascaded deletion.

Idea-2) copy & paste all the declaration after CREATE TYPE in
cube--1.2.sql to the
new script, then create these objects again.

Best regards,

--
HeteroDB, Inc / The PG-Strom Project
KaiGai Kohei <kaigai(at)heterodb(dot)com>