BUG #15229: Crash when using PQgetvalue

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: duncan(dot)reitboeck(at)gmail(dot)com
Subject: BUG #15229: Crash when using PQgetvalue
Date: 2018-06-04 16:28:15
Message-ID: 152812969559.26728.1109379398061677469@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15229
Logged by: Duncan
Email address: duncan(dot)reitboeck(at)gmail(dot)com
PostgreSQL version: 10.4
Operating system: Windows 10
Description:

I am getting a segmentation fault in the below code when attempting to use
PQgetvalue. I am not 100 percent this is a bug and not a problem on my end
but I have done a lot of debugging and not found an answer.

PGconn *con;
PGresult *pg_result;

int i = 0;
int j = 0;
int cols = 0;
int rows = 0;

con = PQconnectdb("host=localhost user=postgres password=test
dbname=test");

if(PQstatus(con) != CONNECTION_OK)
{
printf("Could not connect to PostgreSQL database!");
fflush(stdout);
}
else
{
g_print("Connected.\n");

pg_result = PQexec(con, "SELECT * FROM test");

if(PQresultStatus(pg_result) == PGRES_TUPLES_OK)
{
rows = PQntuples(pg_result);
cols = PQnfields(pg_result);

for(i = 0; i < rows; ++i)
{
for(j = 0; j < cols; ++j)
{
printf("Row: %d - Col: %d = %s\n", i, j, PQgetvalue(pg_result, i,
j));
fflush(stdout);
}
}
}
PQclear(pg_result);
close_pgsql(con);
}

Some of the things I have tried debugging with:
1. Replacing PQgetvalue with PQgetlength.
The correct number of rows and fields are returned and the correct
length is printed for each.

2. Removing printf and simply calling function.
Still crashed at same location.

3. Checking PQgetisnull.
No null returned.

4. Different databases, connections, etc.
Always still crashed when trying to access PQgetvalue.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-06-04 16:55:55 Re: BUG #15229: Crash when using PQgetvalue
Previous Message Suwalka, Kriti 2018-06-04 15:47:40 JDBC Driver42.2.2 throws error when dealing with money datatype