From: | Vinícius Abrahão <vinnix(dot)bsd(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Userland copy of pg_statistic - is there a solution? |
Date: | 2024-09-30 07:31:06 |
Message-ID: | CAM9Bftx6fu1-_qNXTS6T6+VH1F69YzfsMggXGF7JeOzwrOCWLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter | 2024-09-30 09:53:01 | Re: Failing GSSAPI TCP when connecting to server |
Previous Message | Muhammad Usman Khan | 2024-09-30 03:17:46 | Re: Basebackup fails without useful error message |