Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id g1CKjfE67260
	for <pgsql-sql@postgresql.org>; Tue, 12 Feb 2002 15:45:42 -0500 (EST)
	(envelope-from olebedev@waterford.org)
Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org
	(Netscape Messaging Server 3.56)  with ESMTP id 479
	for <pgsql-sql@postgresql.org>; Tue, 12 Feb 2002 13:34:31 -0700
Message-ID: <3C698464.DC9D6218@waterford.org>
Date: Tue, 12 Feb 2002 14:08:53 -0700
From: Oleg Lebedev <olebedev@waterford.org>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Postgres SQL Mailing List <pgsql-sql@postgresql.org>
Subject: pg_atoi error
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200202/136
X-Sequence-Number: 6564

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