Re: [HACKERS] Postgresql10 Bug report. (pg_catalog.pg_statistic_ext does not exist)
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 Lanewrote: > 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)
Alvaro Herrerawrites: > 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)
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)
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