Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svAsl-00Cz9k-Ox for pgsql-general@arkaria.postgresql.org; Mon, 30 Sep 2024 07:31:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1svAsk-00DydY-9Q for pgsql-general@arkaria.postgresql.org; Mon, 30 Sep 2024 07:31:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svAsj-00DydQ-V6 for pgsql-general@lists.postgresql.org; Mon, 30 Sep 2024 07:31:45 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1svAsg-001noo-Ts for pgsql-general@lists.postgresql.org; Mon, 30 Sep 2024 07:31:45 +0000 Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-53988c54ec8so2667740e87.0 for ; Mon, 30 Sep 2024 00:31:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727681503; x=1728286303; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=tUcv63NYx7u+zc8f8Z1a3R+dmxBB6ZQAA5LPb5Iw3oo=; b=giq1w4lx0Mw/xuA0C+06h6hgAnZWRBBhIXbg2BJ8JAcRnz+ltLuI/FgS1724xbGkIz 2KORiPoxZIZvDHbs8ZN8oi713gxkwxGUHEZu947GwQlvQd4mS9q/NkNjZzezN8f/4KA5 4Vca1r7ww3m0xqGvuFYbM2qt83JsuAhlfABHKMnAzs+PZ/Zvxqj9kUO/QwZxNa85u2jL uruiYrmVIXSSSJZ13WInl5byx7DeyQ7YzxCqn3rm9HPKvpi6V77jFHjjvvOCXeRiY5kw Sjgfuuyy41J116cvesxbG8HG0JxYTNtnoyS0GfqAEQRW7bySU1k2GZNhnBce3hgkck6F Xe0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727681503; x=1728286303; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=tUcv63NYx7u+zc8f8Z1a3R+dmxBB6ZQAA5LPb5Iw3oo=; b=LbdAYjZoGDoLhkLZiBjdR8IerS8TRfsHZcQ09rBxvjm8S5uUOVm2GpHIP0zD5bM/qu oqX7/cd07H9h3ZmJmxw4g3XXZUu/n6hBwg4+FbMHeMpgNBOx0A58QIaFKyyZOkKvVleq AAV+TVRQpIa4VwE0cedl9CGBLECMRKiHKfiX0bLf/gwn2DfYQxhRantUJuEwzDO3bCx+ RJHtTNYm85HS9nis3XXaJFKmUOePtfTWAMDW+Ypg9XZSxrcQ15qu7xGZSUd3uaEzb5k/ gldw2cRYGEsavBIGt/y6L9zo6wvR+wUtFUkVaxj4Mj2DQmZNY/FmF4bgQXClYpeKb5o4 b2xQ== X-Gm-Message-State: AOJu0YzXyNDZt/0enbBdaJ4Gb9QSpg4fUXiQ43nU4X20LbmlFcb9jr4J V2nZjlezWOpD/Wez9Ya4cIW4kOwg+u98fAfHJPzejD8R4d7jDD6XugV7LwuT5cnxFVIGfJyKhdM vzdR0Z1uzc+TM6FLKZvKMZaDRblV3eGxi X-Google-Smtp-Source: AGHT+IHZQFE3oKwDo8aLBXGKorBKeYZ2+xiRGngvXEfj/DZLGNajSmkH3VZZmu0I1BrEqRMpcUqdXO2qVPjjlJ7F5gY= X-Received: by 2002:a05:6512:620e:b0:536:a695:9429 with SMTP id 2adb3069b0e04-5389fc344e1mr5584280e87.10.1727681503080; Mon, 30 Sep 2024 00:31:43 -0700 (PDT) MIME-Version: 1.0 From: =?UTF-8?B?Vmluw61jaXVzIEFicmFow6Nv?= Date: Mon, 30 Sep 2024 08:31:06 +0100 Message-ID: Subject: Userland copy of pg_statistic - is there a solution? To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000046ba3b06235132c3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000046ba3b06235132c3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Morning, postgres=3D# create table backup_pg_statistic as select * from pg_statistic= ; 2024-09-30 08:25:56 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,client=3D[local] ERROR: column "sta= values1" has pseudo-type anyarray 2024-09-30 08:25:56 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,client=3D[local] STATEMENT: create = table backup_pg_statistic as select * from pg_statistic; ERROR: column "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,client=3D[local] ERROR: column "a" = has pseudo-type anyarray 2024-09-30 08:26:40 BST [7400]: user=3Dvinnix,db=3Dpostgres,app=3Dpsql,client=3D[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=C3=ADcius --00000000000046ba3b06235132c3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Morn= ing,

postgres=3D# create table backup_pg_statistic as select * from = pg_statistic;
2024-09-30 08:25:56 BST [7400]: user=3Dvinnix,db=3Dpostgre= s,app=3Dpsql,client=3D[local] ERROR: =C2=A0column "stavalues1" ha= s pseudo-type anyarray
2024-09-30 08:25:56 BST [7400]: user=3Dvinnix,db= =3Dpostgres,app=3Dpsql,client=3D[local] STATEMENT: =C2=A0create table backu= p_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]: us= er=3Dvinnix,db=3Dpostgres,app=3Dpsql,client=3D[local] ERROR: =C2=A0column &= quot;a" has pseudo-type anyarray
2024-09-30 08:26:40 BST [7400]: us= er=3Dvinnix,db=3Dpostgres,app=3Dpsql,client=3D[local] STATEMENT: =C2=A0crea= te table test_array(a anyarray);
ERROR: =C2=A0column "a" has p= seudo-type anyarray
Time: 9.137 ms

Is there a solution for this simple problem?

Cheers,
Vin=C3=ADcius
--00000000000046ba3b06235132c3--