Inserting additional data into pg_statistics

Поиск
Список
Период
Сортировка
От Teodor Macicas
Тема Inserting additional data into pg_statistics
Дата
Msg-id 4C1CD986.20704@epfl.ch
обсуждение исходный текст
Ответы Re: Inserting additional data into pg_statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Inserting additional data into pg_statistics  (Teodor Macicas <teodor.macicas@epfl.ch>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Martin Gainty
Дата:
Сообщение: Re: [Blatant Alias Abuse] Anyone want to help out with a coding problem?
Следующее
От: Piero Campa
Дата:
Сообщение: Re: Access remote DB (outside local network) via PgAdmin