| 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: | Whole Thread | Raw Message | 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 |