Thread: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does not exist)
apologies if someone has already reported this.
steps to reproduce.
install PG10 rpms.
create table.
using psql 10 \d the table.
note the error below.
m=# create table mytable (myid serial, mytext text);
CREATE TABLE
m=# \d mytable
ERROR: relation "pg_catalog.pg_statistic_ext" does not exist
LINE 8: FROM pg_catalog.pg_statistic_ext stat WHERE starelid = '163...
^
m=# \q
list of my rpm versions.
[postgres@localhost ~]$ rpm -qa | grep postgresql10
postgresql10-test-10.0-20170406_1PGDG.rhel7.1.x86_64
postgresql10-devel-10.0-20170406_1PGDG.rhel7.1.x86_64
postgresql10-10.0-20170406_1PGDG.rhel7.1.x86_64
postgresql10-contrib-10.0-20170406_1PGDG.rhel7.1.x86_64
postgresql10-server-10.0-20170406_1PGDG.rhel7.1.x86_64
postgresql10-libs-10.0-20170406_1PGDG.rhel7.1.x86_64
postgresql10-debuginfo-10.0-20170406_1PGDG.rhel7.1.x86_64
thanks
-Mark
Re: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_extdoes not exist)
From
Alvaro Herrera
Date:
mark wrote: > m=# create table mytable (myid serial, mytext text); > CREATE TABLE > m=# \d mytable > ERROR: relation "pg_catalog.pg_statistic_ext" does not exist > LINE 8: FROM pg_catalog.pg_statistic_ext stat WHERE starelid = '163... > ^ Ah, what happens is you're using a new psql with a pre-10 server. Yeah, this is a bug since psql is supposed to work fine with older servers too. Thanks for the report, will fix. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Re: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does not exist)
From
Tom Lane
Date:
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> mark wrote:
>> m=# create table mytable (myid serial, mytext text);
>> CREATE TABLE
>> m=# \d mytable
>> ERROR: relation "pg_catalog.pg_statistic_ext" does not exist
> Ah, what happens is you're using a new psql with a pre-10 server. Yeah,
> this is a bug since psql is supposed to work fine with older servers
> too. Thanks for the report, will fix.
No, there is a version test there, and it works fine for me. I think
the OP is somehow using a very recent psql with a v10, but not so recent,
server. Perhaps he didn't restart his server after updating RPMs.
regards, tom lane
it would appear that it didn't restart when I thought it had with the service command.
apologies, I'm not able to reproduce anymore after restarting things. On Thu, Apr 6, 2017 at 11:27 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> mark wrote:
>> m=# create table mytable (myid serial, mytext text);
>> CREATE TABLE
>> m=# \d mytable
>> ERROR: relation "pg_catalog.pg_statistic_ext" does not exist
> Ah, what happens is you're using a new psql with a pre-10 server. Yeah,
> this is a bug since psql is supposed to work fine with older servers
> too. Thanks for the report, will fix.
No, there is a version test there, and it works fine for me. I think
the OP is somehow using a very recent psql with a v10, but not so recent,
server. Perhaps he didn't restart his server after updating RPMs.
regards, tom lane