Displaying 4 results from an estimated 4 matches for "pqfname".
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
2004 Jun 23
0
UPDATE Patch for postgres enabled app_voicemail.c
...k(&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(PGSQLres,k,i));
! } else if (!strcmp(fname, "context")) {
! memset (context, 0, sizeof (context));
! strcpy (context,P...
2004 Jun 23
0
Patch for postgres enabled app_voicemail.c
...k(&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(PGSQLres,k,i));
! } else if (!strcmp(fname, "context")) {
! memset (context, 0, sizeof (context));
! strcpy (context,P...
2010 Apr 14
4
PostgreSQL driver supporting [round-robin] load balancing and redundancy [LONG]
...lds(result->pgr);
+
+ dprintf(("%s: %p: %u", __func__, result, count));
+ return count;
+}
+
+static char const *multi_pgsql_result_get_field_name(struct sql_result *r,
+ unsigned i)
+{
+ struct multi_pgsql_result *result;
+ char const *name;
+
+ result = (void *)r;
+ name = PQfname(result->pgr, i);
+
+ dprintf(("%s: %p: %u: '%s'", __func__, result, i, name));
+ return name;
+}
+
+static int multi_pgsql_result_find_field(struct sql_result *r,
+ char const *fname)
+{
+ struct multi_pgsql_result *result;
+ int i;
+
+ result = (void *)r;
+ i = PQfnumber...