From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Ashok Chauhan <ashok@kalculate.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: ERROR
Date: Sat, 22 Nov 2003 08:14:05 -0800 (PST)
Message-ID: <20031122080919.V14063@megazone.bigpanda.com> (raw)
In-Reply-To: <1069508871.1222.25.camel@chi>
References: <1069508871.1222.25.camel@chi>
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@postgresql.org)
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sszabo@megazone.bigpanda.com, ashok@kalculate.com
Subject: Re: ERROR
In-Reply-To: <20031122080919.V14063@megazone.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox