Search Postgresql Archives

Re: Shouldn;t this trigger be called?

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

 



On Sun, Sep 15, 2019 at 11:33:09AM -0400, stan wrote:
> I have defined this function:
> 
> CREATE FUNCTION fix_customer_types_case()
> 
> and this trigger:
> 
> CREATE TRIGGER fix_customer_types_case_trig BEFORE INSERT OR UPDATE ON customer
> FOR EACH ROW EXECUTE FUNCTION fix_customer_types_case();
> 
> and I put a RAISE NOTICE so I cna tell if the function is called. Yet when I
> do a :
> 
> \copy to bring data into this table, I do not see the notice.
> 
> Shouldn't this fucntion be aclled for that?

Sorry, found my mistake.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin





[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