Thread: pg_atoi error
Hi everybody, I am getting the following error when calling a procedure on one database, but the same procedure runs ok on another database, which is a smaller instance of the former database: ERROR: pg_atoi: error in "Production": can't parse "Production" Inside the procedure I am trying to compare one of the table fields to ''Procedure'' as follows: .. IF OLD.status != ''Procedure'' AND NEW.status=''Procedure'' ... I have no idea what can cause this. Please help. thanks, Oleg
Never mind my previous message. It turns out that the name of the variable I was using inside a function was the same as one of the column names in the record I used inside a loop. thanks, Oleg Oleg Lebedev wrote: > Hi everybody, > I am getting the following error when calling a procedure on one > database, but the same procedure runs ok on another database, which is a > smaller instance of the former database: > ERROR: pg_atoi: error in "Production": can't parse "Production" > > Inside the procedure I am trying to compare one of the table fields to > ''Procedure'' as follows: > .. > IF OLD.status != ''Procedure'' > AND NEW.status=''Procedure'' > ... > > I have no idea what can cause this. > Please help. > > thanks, > > Oleg > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org