Re: Trigger (Transaction related)

"Harpreet Dhaliwal" < harpreet.dhaliwal01@gmail.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