Re: [GENERAL] c program fails to run with the postgres which is installed at user location

2010-06-03 Thread zhong ming wu
On Thu, Jun 3, 2010 at 2:15 AM, John R Pierce wrote: > zhong ming wu wrote: >> >> ... >> This machine is RHEL 5.5 and has both RH stock postgres 8.1.18 in > > you probably need to either use "-R $HOME/local/lib" on the link command to > specify the runtime path to find .so's in, or add $HOME/local

Re: [GENERAL] c program fails to run with the postgres which is installed at user location

2010-06-02 Thread John R Pierce
zhong ming wu wrote: ... This machine is RHEL 5.5 and has both RH stock postgres 8.1.18 in standard location as well as pg 8.4.4 which is in my home folder. The libraries are libpg.so.4 and libpg.so.5 respectively for two versions. I just lifted one of the examples from postgres documentation

[GENERAL] c program fails to run with the postgres which is installed at user location

2010-06-02 Thread zhong ming wu
I am trying to compile and run c program which reads the journal of an ancient propriety database and copy these transactions over to postgres. The process I follow is by trial and error and made worse by the fact that I haven't before made c program which talks to postgres and because I have to u