Re: new table partitioning breaks \d table to older versions

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "[pgdg] Robert Haas" <robertmhaas(at)gmail(dot)com>
Subject: Re: new table partitioning breaks \d table to older versions
Date: 2016-12-09 18:18:57
Message-ID: CAFcNs+qxQsBizSV3imk39A4_Y2rTir91L-8x+1DW+6zeNWoRjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Dec 9, 2016 at 3:59 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
> Since:
>
> commit f0e44751d7175fa3394da2c8f85e3ceb3cdbfe63
> Author: Robert Haas <rhaas(at)postgresql(dot)org>
> Date: Wed Dec 7 13:17:43 2016 -0500
>
> Implement table partitioning.
>
> If I use psql compiled from 10devel to connect to a 9.6.1 server, then \d
fails:
>
> psql (10devel-f0e4475, server 9.6.1-16e7c02)
> Type "help" for help.
>
>
> # \d pgbench_accounts
> ERROR: column c.relpartbound does not exist
> LINE 1: ...ELECT inhparent::pg_catalog.regclass, pg_get_expr(c.relpartb...
>

Looks like they forgot to adjust version check number in describe.c code.

Attched patch fix it.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

Attachment Content-Type Size
fix-psql-after-partition.patch text/x-patch 378 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Keith Fiske 2016-12-09 18:23:44 Re: [COMMITTERS] pgsql: Implement table partitioning.
Previous Message Amit Langote 2016-12-09 18:17:56 Re: new table partitioning breaks \d table to older versions