On Tue, Aug 16, 2005 at 07:19:38PM -0500, Apu Islam wrote: > I have a trigger which is not working properly. > The error I get is parse error at $1. I am putting the code here for > someone to see and comment on. When do you get the error? When you create the function, or when the trigger calls it? What version of PostgreSQL are you using? > INSERT INTO customer_stat VALUES ( > ''NEW.cisconasport'',NEW.h323connecttime,hour,0,0,0,0,0,''p$ The above INSERT command looks odd. Why do you quote NEW.cisconasport? Where does the last pair of single quotes having a closing pair? Where are the closing parenthesis and statement-terminating semicolon? -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
