Displaying 6 results from an estimated 6 matches for "pqntuples".
2004 Jun 23
0
UPDATE Patch for postgres enabled app_voicemail.c
...y: Query Error (%s) Calling
PQreset\n",PQcmdStatus(PGSQLres));
! PQclear(PGSQLres);
! PQreset(dbhandler);
! ast_mutex_unlock(&postgreslock);
! return;
! } else {
! numFields = PQnfields(PGSQLres);
! //fprintf(stdout,"postgres sql_append_user: query found %d rows with %d
fields\n",PQntuples(PGSQLres), numFields);
! for (k = 0; k< (PQntuples(PGSQLres)); k++) {
! for (i=0; i<numFields; i++) {
! fname = PQfname(PGSQLres,i);
! if (!strcmp(fname, "password") && !PQgetisnull (PGSQLres,k,i)) {
! memset (password, 0, sizeof (password));
! strcpy (password,PQgetvalue(PG...
2004 Jun 23
0
Patch for postgres enabled app_voicemail.c
...y: Query Error (%s) Calling
PQreset\n",PQcmdStatus(PGSQLres));
! PQclear(PGSQLres);
! PQreset(dbhandler);
! ast_mutex_unlock(&postgreslock);
! return;
! } else {
! numFields = PQnfields(PGSQLres);
! //fprintf(stdout,"postgres sql_append_user: query found %d rows with %d
fields\n",PQntuples(PGSQLres), numFields);
! for (k = 0; k< (PQntuples(PGSQLres)); k++) {
! for (i=0; i<numFields; i++) {
! fname = PQfname(PGSQLres,i);
! if (!strcmp(fname, "password") && !PQgetisnull (PGSQLres,k,i)) {
! memset (password, 0, sizeof (password));
! strcpy (password,PQgetvalue(PG...
2007 Mar 08
2
RE: Apache Install error on Centos 4.3
...til-1.so: undefined reference to `PQgetResult'
/usr/lib/libaprutil-1.so: undefined reference to `PQconnectdb'
/usr/lib/libaprutil-1.so: undefined reference to `PQexec'
/usr/lib/libaprutil-1.so: undefined reference to `PQexecPrepared'
/usr/lib/libaprutil-1.so: undefined reference to `PQntuples'
/usr/lib/libaprutil-1.so: undefined reference to `PQreset'
/usr/lib/libaprutil-1.so: undefined reference to `PQsendQueryParams'
/usr/lib/libaprutil-1.so: undefined reference to `PQexecParams'
/usr/lib/libaprutil-1.so: undefined reference to `PQclear'
/usr/lib/libaprutil-1.so: u...
2005 Mar 05
2
cant compile app_meetme2
...e2.c:163: warning: implicit declaration of function `PQresultStatus'
app_meetme2.c:163: error: `PGRES_TUPLES_OK' undeclared (first use in this
functi
on)
app_meetme2.c:166: warning: implicit declaration of function `PQclear'
app_meetme2.c:171: warning: implicit declaration of function `PQntuples'
app_meetme2.c:179: warning: implicit declaration of function `PQgetvalue'
app_meetme2.c:179: warning: passing arg 1 of `atoi' makes pointer from
integer w
ithout a cast
app_meetme2.c:180: warning: passing arg 1 of `atoi' makes pointer from
integer w
ithout a cast
app_meetme2.c:18...
2009 Jun 04
2
RPostgreSQL segfault with LEFT JOIN
Hi,
I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the
RPostgreSQL package for interfacing with a postgresql database. I am using
postgresql 8.3.7.
A query that works from the postgresql terminal is causing a segfault when
executed from R.
My sessionInfo, the error message, and the R code used to generate the error
are listed below.
I have noticed that a
2010 Apr 14
4
PostgreSQL driver supporting [round-robin] load balancing and redundancy [LONG]
...>pgr;
+
+ status = PQresultStatus(pgr);
+ dprintf(("%s: %p: result status %s(%d)",
+ __func__, r, PQresStatus(status), status));
+
+ switch (status) {
+ case PGRES_COMMAND_OK:
+ case PGRES_COPY_OUT:
+ case PGRES_COPY_IN:
+ n_rows = 0;
+ break;
+
+ case PGRES_TUPLES_OK:
+ n_rows = PQntuples(pgr);
+
+ dprintf(("%s: %p: %u rows", __func__, result, n_rows));
+ break;
+
+ default:
+ return -1;
+ }
+
+ result->n_rows = n_rows;
+ result->api.v.next_row = multi_pgsql_result_next_row;
+ return n_rows;
+}
+
+static unsigned multi_pgsql_result_get_fields_count(struct sql_re...