Re: Trigger (Transaction related) - Mailing list pgsql-general

"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