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
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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:
Show quoted text
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 existAh, 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