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