pg_atoi error

From: Oleg Lebedev <olebedev(at)waterford(dot)org>
To: Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: pg_atoi error
Date: 2002-02-12 21:08:53
Message-ID: 3C698464.DC9D6218@waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Lebedev 2002-02-12 21:35:24 Re: pg_atoi error
Previous Message Andrew G. Hammond 2002-02-12 17:40:10 Re: SQL request to retrieve the type of columns