Обсуждение: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does not exist)

Поиск
Список
Период
Сортировка

[HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does not exist)

От
mark
Дата:
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)

От
Alvaro Herrera
Дата:
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)

От
Tom Lane
Дата:
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

Re: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_extdoes not exist)

От
mark
Дата:
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