Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7A99A634754
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  2 Sep 2009 12:21:26 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 44048-04-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  2 Sep 2009 15:21:18 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id A5A3F63660D
	for <pgsql-sql@postgresql.org>; Wed,  2 Sep 2009 12:19:16 -0300 (ADT)
Received: from in02.mta.xmission.com ([166.70.13.52])
	by out01.mta.xmission.com with esmtp (Exim 4.62)
	(envelope-from <robjsargent@gmail.com>)
	id 1MircR-0001Pw-E0; Wed, 02 Sep 2009 09:19:31 -0600
Received: from [208.187.158.94] (helo=[172.16.1.232])
	by in02.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1MircA-00077k-9p; Wed, 02 Sep 2009 09:19:14 -0600
Message-ID: <4A9E8CF0.7000607@gmail.com>
Date: Wed, 02 Sep 2009 09:19:12 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: aymen marouani <marouani.aymen@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Question
References: <bebe9cb90909020728we0a60eexa368cb07135896da@mail.gmail.com>
In-Reply-To: <bebe9cb90909020728we0a60eexa368cb07135896da@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in02.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: marouani.aymen@gmail.com, pgsql-sql@postgresql.org,
	robjsargent@gmail.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: No (on in02.mta.xmission.com); Unknown failure
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.74 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, RCVD_IN_DNSWL_LOW=-1
X-Spam-Level: 
X-Archive-Number: 200909/15
X-Sequence-Number: 33080

Call nextval first?

Too many quotes?

aymen marouani wrote:
> Hi for all, 
> What is the possible sources of the SQLState 55000 "OBJECT NOT IN 
> PREREQUISITE STATE" ? 
> The error 55000 was triggered when I executed the following query :
> "select currval('"BatchTreatment_batch_treatment_id_seq"');" 
>
> Thanks in advance. 
>
> Cordially.