search for: pqresultstatus

...stgres sql_append_user:\n"); ! ! sprintf(query, "SELECT * FROM voicemail order by context,mailbox "); ! ! //fprintf(stdout,"postgres sql_append_user: query = %s\n",query); ! ast_mutex_lock(&postgreslock); ! PGSQLres=PQexec(dbhandler,query); ! if (PGSQLres!=NULL) { ! if (PQresultStatus(PGSQLres) == PGRES_BAD_RESPONSE || ! PQresultStatus(PGSQLres) == PGRES_NONFATAL_ERROR || ! PQresultStatus(PGSQLres) == PGRES_FATAL_ERROR) { ! ! ast_log(LOG_WARNING,"PGSQL_query: Query Error (%s) Calling PQreset\n",PQcmdStatus(PGSQLres)); ! PQclear(PGSQLres); ! PQreset(dbhandler); ! ast_mu...

Dear list, I have a small issue with dovecot talking to a postgresql server: If my postgres server get restarted, dovecot fails to reconnect to the postgres server. I run dovecot 0.99.9.1 (which is actually a cvs version of dovecot, of may 9 2003) I have the same postgres version for the server as I use for the libraries. Is it hard to get auto-reconnect to work? Kind regards, Maikel

...stgres sql_append_user:\n"); ! ! sprintf(query, "SELECT * FROM voicemail order by context,mailbox "); ! ! //fprintf(stdout,"postgres sql_append_user: query = %s\n",query); ! ast_mutex_lock(&postgreslock); ! PGSQLres=PQexec(dbhandler,query); ! if (PGSQLres!=NULL) { ! if (PQresultStatus(PGSQLres) == PGRES_BAD_RESPONSE || ! PQresultStatus(PGSQLres) == PGRES_NONFATAL_ERROR || ! PQresultStatus(PGSQLres) == PGRES_FATAL_ERROR) { ! ! ast_log(LOG_WARNING,"PGSQL_query: Query Error (%s) Calling PQreset\n",PQcmdStatus(PGSQLres)); ! PQclear(PGSQLres); ! PQreset(dbhandler); ! ast_mu...

...il-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: undefined reference to `PQresultStatus' /usr/lib/libaprutil-1.so: undefined reference to `PQgetvalue' /usr/lib/libaprutil-1.so: undefined reference to `PQstatus' /usr/lib/libaprutil-1.so: undefined reference to `PQnfields' /usr/lib/libaprutil-1.so: undefined reference to `PQcmdTuples' /usr/lib/libaprutil-1.so: undefi...

...QerrorMessage' app_meetme2.c:154: warning: format argument is not a pointer (arg 6) app_meetme2.c:155: warning: implicit declaration of function `PQfinish' app_meetme2.c:162: warning: implicit declaration of function `PQexec' app_meetme2.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...

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

...row < result->n_rows) return result->row = row; + return 0; +} + +static int multi_pgsql_result_first_row(struct sql_result *r) +{ + struct multi_pgsql_result *result; + PGresult *pgr; + ExecStatusType status; + unsigned n_rows; + + result = (void *)r; + pgr = result->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((&quot...