No you don't have to buy it.You may have installed the server only, but you may need the development rpm also. Try to find all additional rpm for Postgres and install them.
The next best thing is to download the source and recompile it. If you do that type ./configure --prefix=/usr instead of ./configure alone. When software are installed from rpm they are usually put in /usr/bin whereas the GNU default directory is /usr/local/bin.
----- Original Message -----
From: nimeshb
To: pgsql-novice(at)postgresql(dot)org ; pgadmin-support(at)postgresql(dot)org ; pgsql-ports(at)postgresql(dot)org
Sent: Thursday, May 30, 2002 3:00 AM
Subject: [PORTS] ecpg not found
I am trying to port my data from Ingres to Postgres( that has come with Linux distribution)
I found that Ingres prepends all the strings from database with the no. of characters while unloading.
So if a varchar-filed in Ingres has "Syscon" as the value it would have "6Syscon" when unloaded.
But When I reloaded the whole data in Postgres I had "6Syscon" in my database.So I wanted
to write a C programme with embedded Sql to take care of all such bad-data. But I get the ecpg not found.
I checked all the bin directories where it could be but couldn't found.Do I need to buy the stuff and install it.
If yes then how and from whom.
Thanks very much !
Nimesh