Message-ID: <cf5b075842bfeffe7e2d0b3a90cb311af1a6457c.camel@cybertec.at>
Subject: Re: Userland copy of pg_statistic - is there a solution?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?ISO-8859-1?Q?Vin=EDcius_Abrah=E3o?= <vinnix.bsd@gmail.com>, 
	pgsql-general@lists.postgresql.org
Date: Mon, 30 Sep 2024 12:05:52 +0200
In-Reply-To: <CAM9Bftx6fu1-_qNXTS6T6+VH1F69YzfsMggXGF7JeOzwrOCWLQ@mail.gmail.com>
References: 
	<CAM9Bftx6fu1-_qNXTS6T6+VH1F69YzfsMggXGF7JeOzwrOCWLQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/cf5b075842bfeffe7e2d0b3a90cb311af1a6457c.camel%40cybertec.at>
Precedence: bulk

On Mon, 2024-09-30 at 08:31 +0100, Vin=C3=ADcius Abrah=C3=A3o wrote:
> postgres=3D# create table backup_pg_statistic as select * from pg_statist=
ic;
> 2024-09-30 08:25:56 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,cl=
ient=3D[local] ERROR: =C2=A0column "stavalues1" has pseudo-type anyarray
> 2024-09-30 08:25:56 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,cl=
ient=3D[local] STATEMENT: =C2=A0create table backup_pg_statistic as select =
* from pg_statistic;
> ERROR: =C2=A0column "stavalues1" has pseudo-type anyarray
> Time: 9.544 ms
> postgres=3D# create table test_array(a anyarray);
> 2024-09-30 08:26:40 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,cl=
ient=3D[local] ERROR: =C2=A0column "a" has pseudo-type anyarray
> 2024-09-30 08:26:40 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,cl=
ient=3D[local] STATEMENT: =C2=A0create table test_array(a anyarray);
> ERROR: =C2=A0column "a" has pseudo-type anyarray
> Time: 9.137 ms
>=20
>=20
> Is there a solution for this simple problem?

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

Yours,
Laurenz Albe