Postgres Pro
Downloads
Home   >   mailing lists

Userland copy of pg_statistic - is there a solution? - Mailing list pgsql-general

From Vinícius Abrahão
Subject Userland copy of pg_statistic - is there a solution?
Date
Msg-id CAM9Bftx6fu1-_qNXTS6T6+VH1F69YzfsMggXGF7JeOzwrOCWLQ@mail.gmail.com
Whole thread Raw
Responses Re: Userland copy of pg_statistic - is there a solution?
Re: Userland copy of pg_statistic - is there a solution?
List pgsql-general
Tree view

Morning,

postgres=# create table backup_pg_statistic as select * from pg_statistic;
2024-09-30 08:25:56 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] ERROR:  column "stavalues1" has pseudo-type anyarray
2024-09-30 08:25:56 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] STATEMENT:  create table backup_pg_statistic as select * from pg_statistic;
ERROR:  column "stavalues1" has pseudo-type anyarray
Time: 9.544 ms
postgres=# create table test_array(a anyarray);
2024-09-30 08:26:40 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] ERROR:  column "a" has pseudo-type anyarray
2024-09-30 08:26:40 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] STATEMENT:  create table test_array(a anyarray);
ERROR:  column "a" has pseudo-type anyarray
Time: 9.137 ms

Is there a solution for this simple problem?

Cheers,
Vinícius

pgsql-general by date:

Previous
From: Muhammad Usman Khan
Date:
Subject: Re: Basebackup fails without useful error message
Next
From: Peter
Date:
Subject: Re: Failing GSSAPI TCP when connecting to server