Re: error in code - Mailing list pgsql-admin

From Stephen Powell
Subject Re: error in code
Date
Msg-id u3cbsi09z.fsf@privacy.net
Whole thread Raw
In response to error in code  (Ashok Chauhan <ashok@kalculate.com>)
List pgsql-admin
On 10 Dec 2003, ashok@kalculate.com wrote:

> I written a code

[...]

Checking for errors is good:

# include <stdio.h>
# include <stdlib.h>
# include <libpq-fe.h>

int main()
{
        PGresult *result = NULL;
        PGconn *conn = NULL;
        int feild;
        printf("successful");
        conn = PQconnectdb ("ashok");
  if (!conn || CONNECTION_BAD == PQstatus(conn)) {
    fprintf(stderr, "Connection to database failed.\n");
    fprintf(stderr, "%s", PQerrorMessage(conn));
    exit(EXIT_FAILURE);
  }
        result = PQexec (conn, "select * from bill");
  if (!result || PGRES_TUPLES_OK != PQresultStatus(result)) {
    fprintf(stderr, "select command returned no tuples\n");
    fprintf(stderr, "%s", PQerrorMessage(conn));
    exit(EXIT_FAILURE);
  }
        feild = PQntuples (result);
        printf("%d",feild);
        PQclear (result);
        PQfinish (conn);
        printf("hello");
        return EXIT_SUCCESS;
}

> when i run the a.out it give nothing.

Not even "successful" or "hello" from the printfs?

> plz help me.

Download the programmers manual from here <http://www.postgresql.org/docs/>

--
Stephen Powell

pgsql-admin by date:

Previous
From: Christopher Browne
Date:
Subject: Re: 2CPU 4GBRAM
Next
From: Chitta Ranjan Mishra
Date:
Subject: Help---- Urgent