Re: Userland copy of pg_statistic - is there a solution?

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>

To: Vinícius Abrahão <vinnix.bsd@gmail.com>, pgsql-general@lists.postgresql.org

Date: 2024-09-30T10:05:52Z

Lists: pgsql-general

On Mon, 2024-09-30 at 08:31 +0100, Vinícius Abrahão wrote:
> 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?

Use a text[] for your copy of the stavalues* columns.

Yours,
Laurenz Albe