Thread: [HACKERS] new table partitioning breaks \d table to older versions
Since:
commit f0e44751d7175fa3394da2c8f85e3ceb3cdbfe63
Author: Robert Haas <rhaas@postgresql.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...
Cheers,
Jeff
On Sat, Dec 10, 2016 at 2:59 AM, Jeff Janes <jeff.janes@gmail.com> wrote: > Since: > > commit f0e44751d7175fa3394da2c8f85e3ceb3cdbfe63 > Author: Robert Haas <rhaas@postgresql.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... Oops, server version check was added to the relevant code for pg_dump, but not psql... Will send a patch soon. Thanks for catching it. Thanks, Amit
Re: [HACKERS] new table partitioning breaks \d table to older versions
From
Fabrízio de Royes Mello
Date:
On Fri, Dec 9, 2016 at 3:59 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
>
> Since:
>
> commit f0e44751d7175fa3394da2c8f85e3ceb3cdbfe63
> Author: Robert Haas <rhaas@postgresql.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...
>
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
On Fri, Dec 9, 2016 at 10:18 AM, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote:
Looks like they forgot to adjust version check number in describe.c code.
On Fri, Dec 9, 2016 at 3:59 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
>
> Since:
>
> commit f0e44751d7175fa3394da2c8f85e3ceb3cdbfe63
> Author: Robert Haas <rhaas@postgresql.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...
>Attched patch fix it.
Tested (but not read) and it fixes it for me. thanks.
Jeff
On Fri, Dec 9, 2016 at 1:18 PM, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote: > On Fri, Dec 9, 2016 at 3:59 PM, Jeff Janes <jeff.janes@gmail.com> wrote: >> Since: >> commit f0e44751d7175fa3394da2c8f85e3ceb3cdbfe63 >> Author: Robert Haas <rhaas@postgresql.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. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company