# 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
