From: Teodor Macicas <teodor.macicas@epfl.ch>
To: pgsql-admin@postgresql.org
Subject: Inserting additional data into pg_statistics
Date: Sat, 19 Jun 2010 16:33:59 +0200
Message-ID: <4C1CD557.1070403@epfl.ch> (raw)
Hello everyone,
I'm new here, but I have a problem and couldn't find a solution so I
hope you will help me.
I'm trying to reproduce the pg_statistics catalog from one database
server to another one. To retrieve the data from the first server was a
trivial job. The trouble was when I tryied to insert new record to
pg_statistic table on the second server.
To be more precise, I want to run this [0] query and I'm struggling with
this error [1]. The query is generated by pg_dump. Anyways, it will be
the same problem if I write the SQL statement by hand.
So, has anyone any ideas how can I insert new record to pg_statistics
system catalog ?
[0] INSERT INTO pg_statistic
VALUES (
54655,1,0,26,-1,2,3,0,0,1058,1058,0,0,null,'{1}',null,null,'{"AFRICA
","AMERICA"}',null,null,null );
[1] SQL error:
ERROR: cannot accept a value of type anyarray
Thank you a lot.
Looking forward for your replies.
-Tedy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: teodor.macicas@epfl.ch
Subject: Re: Inserting additional data into pg_statistics
In-Reply-To: <4C1CD557.1070403@epfl.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox