Re: [GENERAL] column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!

2009-06-09 Thread G. Allegri
|| ';'; I though that double apices would quote. That was the error. quote_literal() solves it. 2009/6/9 Stephan Szabo : > On Tue, 9 Jun 2009, G. Allegri wrote: > >> Hello list. >> I'm a newbie with plpgsql, so I'm sorry for doing stupid questions... >>

Re: [GENERAL] column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!

2009-06-09 Thread G. Allegri
Great, quote_literal() solved it! It was so easy :) Thx Richard 2009/6/9 Richard Huxton : > G. Allegri wrote: >> >> ERROR: Column 'lets_try' does not exist >> LINE 1: INSERT INTO seconda (nome) VALUES ('lets_try') >> >> My function and trigger

[GENERAL] column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!

2009-06-09 Thread G. Allegri
Hello list. I'm a newbie with plpgsql, so I'm sorry for doing stupid questions... I have a situation whit one table where items are related to two other tables through a common id (unique in the first table) and the table name. Whenever the user execute an operation on an item of the first one ("pr