search for: pqexec

Dear All, Why does my configure fail like so: checking for pg_config... /usr/local/pgsql/8.2.4/bin/pg_config checking for PQexec in -lpq... no configure: *** configure: *** The PostgreSQL installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** including --without-postgres Configure options are: env CC=/usr/local/bin/gcc ./configure --with-ssl=/usr/l...

...copy.c -o RS-pgsql-copy.o gcc -std=gnu99 -I/usr/local/lib64/R/include -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-getResult.c -o RS-pgsql-getResult.o gcc -std=gnu99 -I/usr/local/lib64/R/include -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-pqexec.c -o RS-pgsql-pqexec.o gcc -std=gnu99 -shared -L/usr/local/lib64 -o RPostgreSQL.so RS-DBI.o RS-PQescape.o RS-PostgreSQL.o RS-pgsql-copy.o RS-pgsql-getResult.o RS-pgsql-pqexec.o -L/usr/lib -lpq /usr/bin/ld: cannot find -lpq collect2: error: ld returned 1 exit status make: *** [RPostgreSQL.so] Error...

...pager[90] = ""; ! ! //fprintf(stdout,"postgres 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(...

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

...pager[90] = ""; ! ! //fprintf(stdout,"postgres 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(...

Hi, I successfully installed postgres and prepaid application in my asterisk box but after I digited the code I receive this error: ERROR: Function asterisk_authenticate("unknown", "unknown") does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts -- Playing 'prepaid-no-aaa'

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

...l /usr/bin/ld: warning: libpq.so.4, needed by /usr/lib/libaprutil-1.so, not found (try using -rpath or -rpath-link) /usr/lib/libaprutil-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.s...

...functio n) app_meetme2.c:154: warning: implicit declaration of function `PQerrorMessage' 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 declaratio...