"Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com> writes:
> sprintf(buffer, "INSERT INTO headers (id, header_content) VALUES ( %d,
> SELECT contents FROM parser WHERE id = %d ), id, id);
> SPI_exec(buffer,0).
You're short some parentheses --- try executing a comparable query
manually.
regards, tom lane