--0016364c67235ceab10473039752
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
On Mon, Sep 7, 2009 at 8:48 PM, Richy Gerard <idbisoft [at] gmail.com> wrote:
> While using embedded sql in postgres,
> a. Installed the ecpg library
> b. after installation i couldn't compile the program prog1.c
> ERROR:
> richy [at] ubuntu:~/Desktop$ ecpg prog1.pgc
> richy [at] ubuntu:~/Desktop$ cc -c prog1.c
> prog1.c:3:22: error: ecpgtype.h: No such file or directory
> prog1.c:4:21: error: ecpglib.h: No such file or directory
> prog1.c:5:23: error: ecpgerrno.h: No such file or directory
> prog1.c:6:19: error: sqlca.h: No such file or directory
> prog1.pgc:1: error: expected =91=3D=92, =91,=92, =91;=92, =91asm=92 or =
=91__attribute__=92 before
> =91into=92
> prog1.pgc:1:26: warning: multi-character character constant
>
>
>
>
> Follow the below steps to execute the embedded sql program in postgres
(1) ./ecpg -t test.pgc
(2) export LD_LIBRARY_PATH=3D/usr/local/pgsql/lib
(3) gcc -o test test.c -lpgport -lz -lreadline -ltermcap -lcrypt -lxml2
-lresolv -lnsl -ldl -lm -lbsd -lecpg -lpq -I /usr/local/pgsql/include/ -L
/usr/local/pgsql/lib -lpgtypes
(4) ./test
Regards
Raghu Ram
--0016364c67235ceab10473039752
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
<br><br><div class=3D"gmail_quote">On Mon, Sep 7, 2009 at 8:48 PM, Richy Ge=
rard <span dir=3D"ltr"><<a href=3D"mailto:idbisoft [at] gmail.com">idbisoft [at] g=
mail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" style=
=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; p=
adding-left: 1ex;">
<div>While using embedded sql in postgres, <br clear=3D"all"></div><div>a. =
Installed the ecpg library</div><div>b. after installation i couldn't c=
ompile the program prog1.c</div><div></div><div></div><div>ERROR:</div><div=
>
</div><div>richy [at] ubuntu:~/Desktop$ ecpg prog1.pgc<br>richy [at] ubuntu:~/Desktop=
$ cc -c prog1.c<br>prog1.c:3:22: error: ecpgtype.h: No such file or directo=
ry<br>prog1.c:4:21: error: ecpglib.h: No such file or directory<br>prog1.c:=
5:23: error: ecpgerrno.h: No such file or directory<br>
prog1.c:6:19: error: sqlca.h: No such file or directory<br>prog1.pgc:1: err=
or: expected =91=3D=92, =91,=92, =91;=92, =91asm=92 or =91__attribute__=92 =
before =91into=92<br>prog1.pgc:1:26: warning: multi-character character con=
stant<br><br><br></div>
<br><font color=3D"#888888"><br>
</font></blockquote></div><meta http-equiv=3D"Content-Type" content=3D"text=
/html; charset=3Dutf-8"><meta name=3D"ProgId" content=3D"Word.Document"><me=
ta name=3D"Generator" content=3D"Microsoft Word 11"><meta name=3D"Originato=
r" content=3D"Microsoft Word 11"><link rel=3D"File-List" href=3D"file:///C:=
%5CDOCUME%7E1%5Cedb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Ccl ip_filelist.xml=
"><style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<p class=3D"MsoNormal">Follow the below steps to execute the embedded sql p=
rogram in postgres</p>
<p class=3D"MsoNormal">=A0</p>
<p class=3D"MsoNormal">=A0(1) <span style=3D"">=A0</span>./ecpg -t
test.pgc</p>
<p class=3D"MsoNormal">=A0</p>
<p class=3D"MsoNormal">(2) export LD_LIBRARY_PATH=3D/usr/local/pgsql/lib</p=
>
<p class=3D"MsoNormal">=A0</p>
<p class=3D"MsoNormal">(3) gcc -o test test.c -lpgport -lz -lreadline -lter=
mcap -lcrypt
-lxml2 -lresolv -lnsl -ldl -lm -lbsd -lecpg -lpq -I /usr/local/pgsql/includ=
e/
-L /usr/local/pgsql/lib -lpgtypes</p>
<p class=3D"MsoNormal">=A0</p>
<p class=3D"MsoNormal">(4) <span style=3D"">=A0</span>./test</p><p class=3D=
"MsoNormal"><br></p><p class=3D"MsoNormal"><br></p><p class=3D"MsoNormal">R=
egards</p><p class=3D"MsoNormal">Raghu Ram<br></p>
<input id=3D"gwProxy" type=3D"hidden"><input onclick=3D"jsCall();" id=3D"js=
Proxy" type=3D"hidden"><div id=3D"refHTML"></div>
--0016364c67235ceab10473039752--
