From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Krishnaprasad <k(dot)krishna(at)hcl(dot)in> |
Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Regarding PL/SQL with C |
Date: | 2006-02-25 15:18:52 |
Message-ID: | 20060225151852.GA58695@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sat, Feb 25, 2006 at 02:03:51PM +0530, Krishnaprasad wrote:
> I have written code for connecting to a database and select one row and
> just print it out.. Iam able to make a connection with the databse. But
> after connection it is showing that select query failed.... but if iam
> directly selecting through PL/SQL prompt iam able to do the same.......
You're connecting to the database thusly:
> conn = PQconnectStart("user=postgres,dbname=krishna");
Parameters in the connect string should be space-separated, not
comma-separated. The select is probably failing because the connect
failed; you're not seeing the connection failure because you're
calling PQconnectStart to make a nonblocking connection and you're
not waiting for the connection to complete before making the query.
Unless you need a nonblocking connection use PQconnectdb instead:
conn = PQconnectdb("user=postgres dbname=krishna");
Then check for CONNECTION_OK, not CONNECTION_MADE.
When an operation has failed, you can use PQerrorMessage or
PQresultErrorMessage to display the reason.
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | me | 2006-02-25 18:26:07 | tsearch2: rebuilding of fulltext index |
Previous Message | Juan Ravera | 2006-02-25 14:06:36 | UNSUSCRIBE |