Postgres Pro
Downloads
Home   >   mailing lists

Thread: ecpg not found

ecpg not found

From
"nimeshb"
Date:
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
 

Re: ecpg not found

From
"nimeshb"
Date:
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

Re: [PORTS] ecpg not found

From
"Nicolas Bazin"
Date:
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
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
 

Re: [NOVICE] [PORTS] ecpg not found

From
"Joshua b. Jore"
Date:
Slightly better, if you are going to compile from source then remove your
existing rpms and leave prefix at /usr/local since what you want to avoid
is installing this directly into /usr/bin /usr/include /usr/lib. That's
the worst of the worlds - mixing non-default stuff in the system /usr
area. Oof. That would be painful to cleanup later

Joshua b. Jore ; http://www.greentechnologist.org ; 1121 1233 1311 200
1201 1302 1211 200 1201 1303 200 1300 1233 1313 1211 1302 1212 1311 1230
200 1201 1303 200 1321 1233 1311 1302 200 1211 1232 1211 1231 1321 200
1310 1220 1221 1232 1223 1303 200 1321 1233 1311 200 1201 1302 1211 232
200 1112 1233 1310 1211 200 1013 1302 1211 1211 1232 201 22

On Mon, 3 Jun 2002, Nicolas Bazin wrote:

> 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@postgresql.org ; pgadmin-support@postgresql.org ; pgsql-ports@postgresql.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
>
>