Re: Segmentation fault in PQexec

Hello,

I found the error was in another part of the program. There was a pointer writing mistakenly somewhere in the program code, and somehow it affected PQexec().

Sorry for the inconvenience,
Victor

-----Mensaje original-----
De: Jaime Casanova [mailto:jaime(dot)casanova(at)2ndquadrant(dot)com]
Enviado el: domingo, 04 de diciembre de 2016 2:01
Para: VICTOR MIGUEL MORALES CAYUELA <victormiguel(dot)moralescayuela(at)telefonica(dot)com>
CC: pgsql-bugs(at)postgresql(dot)org
Asunto: Re: [BUGS] Segmentation fault in PQexec

On 3 December 2016 at 11:26, VICTOR MIGUEL MORALES CAYUELA <victormiguel(dot)moralescayuela(at)telefonica(dot)com> wrote:
>
> Hello,
>
> I receive a segmentation fault signal calling PQexec function with an already established connection and a valid SQL query, as frame #4 shows.
>
> I printed both the connection variable (conexion_bbdd) and the SQL query variable (sql_formateado) and both are valid.
>

sorry, this is actually very little information to work with.
i made a simple program and wasn't able to reproduce your problem.

Do you reproduce this consistently? can you make a simpler program that reproduces the problem you're seeing?
Are you sure the problem is not in your own code? specially, look at the size of the "sql_formateado" variable.

sending code as images is not very nice btw.

PS: are you sure your problem is not fixed in 9.6.1?

--
Jaime Casanova www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services