Search Postgresql Archives

Re: Trigger (Transaction related)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



# harpreet.dhaliwal01@xxxxxxxxx / 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux