Re: Trigger (Transaction related)

Exactly Tom,
I was missing a few paranthesis like a nut.
Thanks for pointing out.

Thanks and regards

~Harpreet

On 9/1/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "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
>