Re: [GENERAL] what is the meaning of Datum?

2010-06-23 Thread Teodor Macicas
Tom Lane wrote: Luca Ferrari writes: ok this is a silly question, but I've got a doubt: what is the exact meaning of Datum? It's the backend-internal representation of a single value of any SQL data type. The code using the Datum has to know which type it is, since the Datum itself d

Re: [GENERAL] Inserting additional data into pg_statistics

2010-06-21 Thread Teodor Macicas
fail us. -Dash Debabrata Tom Lane wrote: Teodor Macicas writes: 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 an

Re: [GENERAL] Inserting additional data into pg_statistics

2010-06-20 Thread Teodor Macicas
Sorry for being so insistent, but I need to solve this one and I think that you can help me. Is here anyone who faced the same situation / problem ? If it is, please tell me how can I manually insert records into pg_statistics. Thank you again. Regards, Tedy Teodor Macicas wrote: Hello

Re: [GENERAL] Inserting additional data into pg_statistics

2010-06-19 Thread Teodor Macicas
Hi Tom, Thank you again for your quick reply. Shall we pass the reason for I want to do this ? I can explain, but it's a long story. The idea is that *for sure* I need those metadata there. I want to use them on the second machine. Regards, Tedy Tom Lane wrote: Teodor Macicas w

Re: [GENERAL] Inserting additional data into pg_statistics

2010-06-19 Thread Teodor Macicas
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 writes: I'm

[GENERAL] Inserting additional data into pg_statistics

2010-06-19 Thread Teodor Macicas
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 ins