Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5F33A63555E for ; Thu, 3 Sep 2009 04:14:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 46730-03-7 for ; Thu, 3 Sep 2009 07:14:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.177]) by mail.postgresql.org (Postfix) with ESMTP id 965E563FF9D for ; Thu, 3 Sep 2009 03:32:03 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mreu1) with ESMTP (Nemesis) id 0MKv1o-1Mj5rV17hk-000Gw5; Thu, 03 Sep 2009 08:32:01 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1Mj5rU-0004yh-00 for pgsql-sql@postgresql.org; Thu, 03 Sep 2009 08:32:00 +0200 Date: Thu, 3 Sep 2009 08:32:00 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Question Message-ID: <20090903063200.GA18836@a-kretschmer.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1+bIY680JhCa+igJZbhh+I0JTpIyl07M1NPo5i YDANavupeeG5dmvKMsCejNtax6o9ndcCz6HI7LpELbmJpuFBLJ vHGF+bEjfTpZrAUNiM4zg== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.172 tagged_above=-10 required=5 tests=AWL=0.427, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200909/20 X-Sequence-Number: 33085 In response to aymen marouani : > 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"');" Within this session, first call nextval() for this sequence. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net