Thats OK, but my question is why did the original insert not take place.
Syntax error was in the select query that is fired as a result of the trigger
Thanks,
~Harpreet
On 9/1/06, Roman Neuhauser <neuhauser@sigpipe.cz> wrote: # harpreet.dhaliwal01@gmail.com / 2006-09-01 03:19:03 -0400:
> If that is the case then why does it throw error in one on the insert
> queries in the shared object written in SPI without inserting the row on the
> table on which record is inserted.
>
> Follwing query in the shared object throws an error.
>
>
> INSERT INTO headers (id, header_content) VALUES (1, SELECT raw_email FROM
> parser WHERE id = 1)
>
> Error is
> ERROR: syntax error at or near "SELECT" at character 53
Because there's a syntax error.
test=# INSERT INTO headers (id, header_content) VALUES (1, SELECT raw_email FROM parser WHERE id = 1);
ERROR: syntax error at or near "SELECT" at character 53
LINE 1: ...SERT INTO headers (id, header_content) VALUES (1, SELECT raw...
^
test=# INSERT INTO headers (id, header_content) VALUES (1, (SELECT raw_email FROM parser WHERE id = 1));
ERROR: relation "headers" does not exist
test=#
> Regardless the error in the shared object, why doesn't it insert the
> row in the table on which AFTER INSERT trigger is written?
Perhaps you should verify the syntax of your queries in a less
demanding environment, like psql, first.
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991