Re: ERROR

On Sat, 22 Nov 2003, Ashok Chauhan wrote:

>
> # include <stdlib.h>
> # include <libpq-fe.h>
> int main()
> {
> int feild;
> PGresult *result;
> PGconn *conn;
> conn = PQconnectdb("database");
> result = PQexec (conn, "select * from teblename");
> feild = PQntuples (result);
> printf("%d",feild);
> PQclear(result);
> PQfinish (conn);
> return (1);
>
> }
>
> I RUN THE ABOVE PROGRAM BUT IT GIVE SOME ERRORS THAT ARE FOLLOWS:-

Are you sure you're running the program when you get these errors as
opposed to compiling/linking? The below look like linking errors you'd
get if you forgot to specify that you want to link with libpq.

If you're using gcc, you probably want at least -lpq and possibly a
-L<directory containing libpq.a> on the commandline.

>
> /tmp/ccApFcdl.o: In function `main':
> /tmp/ccApFcdl.o(.text+0x19): undefined reference to `PQconnectdb'
> /tmp/ccApFcdl.o(.text+0x2f): undefined reference to `PQexec'
> /tmp/ccApFcdl.o(.text+0x40): undefined reference to `PQntuples'
> /tmp/ccApFcdl.o(.text+0x64): undefined reference to `PQclear'
> /tmp/ccApFcdl.o(.text+0x72): undefined reference to `PQfinish'
> collect2: ld returned 1 exit status
>
> HELP ME
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>