Re: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does 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  wrote:

> Alvaro Herrera  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_ext does not exist)

[Tom Lane]

Alvaro Herrera  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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does 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 Herrerahttps://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[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