Re: Inserting additional data into pg_statistics
От | Teodor Macicas |
---|---|
Тема | Re: Inserting additional data into pg_statistics |
Дата | |
Msg-id | 4C1D0336.4090207@epfl.ch обсуждение исходный текст |
Ответ на | Re: Inserting additional data into pg_statistics (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Inserting additional data into pg_statistics
|
Список | pgsql-general |
Thank you for your reply, Tom. Why I can't ? And for my purpose is not a bad idea. I mean, I have to do this and somehow I should find a solution. In order to use ANALYZE I need the same data on 2nd machine, but the data is quite large and the only information I need are the statistics from pg_statistic. So, why I receive that ERROR and I run the INSERT statement ? Can anyone tell me where to look into Postgresql source to see how the engine updates this table ? Looking forward for reply. With kindest regards, Tedy Tom Lane wrote: > Teodor Macicas <teodor.macicas@epfl.ch> writes: > >> I'm trying to reproduce the pg_statistics catalog from one database >> server to another one. >> > > You can't really, and manually fooling with system catalogs is usually > a bad idea anyway. Just run ANALYZE. > > regards, tom lane >
В списке pgsql-general по дате отправления: