public inbox for [email protected]help / color / mirror / Atom feed
Userland copy of pg_statistic - is there a solution? 3+ messages / 2 participants [nested] [flat]
* Userland copy of pg_statistic - is there a solution? @ 2024-09-30 07:31 Vinícius Abrahão <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Vinícius Abrahão @ 2024-09-30 07:31 UTC (permalink / raw) To: [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Userland copy of pg_statistic - is there a solution? @ 2024-09-30 10:05 Laurenz Albe <[email protected]> parent: Vinícius Abrahão <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Laurenz Albe @ 2024-09-30 10:05 UTC (permalink / raw) To: Vinícius Abrahão <[email protected]>; [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Userland copy of pg_statistic - is there a solution? @ 2024-10-03 11:29 Vinícius Abrahão <[email protected]> parent: Vinícius Abrahão <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Vinícius Abrahão @ 2024-10-03 11:29 UTC (permalink / raw) To: [email protected] On Mon, Sep 30, 2024 at 8:31 AM Vinícius Abrahão <[email protected]> wrote: > > 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 > Following up my own question - I could overcome this limitation observing the parameter allow_system_table_mods postgres=# set allow_system_table_mods to on; SET Time: 5.190 ms postgres=# create table a(a anyarray) ; CREATE TABLE Time: 132.959 ms This is verified at heap_create_with_catalog(...). PostgreSQL code https://github.com/postgres/postgres/blob/master/src/backend/catalog/heap.c#L1151 If someone needs a patch let me know to make it work for other users. We can work on this together. -- vinnix aka: Vinícius Abrahão Bazana Schmidt twitter.com/vischmidt ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-10-03 11:29 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-09-30 07:31 Userland copy of pg_statistic - is there a solution? Vinícius Abrahão <[email protected]> 2024-09-30 10:05 ` Laurenz Albe <[email protected]> 2024-10-03 11:29 ` Vinícius Abrahão <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox