Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 863CC47580D
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 16:51:53 -0400 (EDT)
Received: from wilson.acpub.duke.edu (wilson.acpub.duke.edu [152.3.233.69])
	by postgresql.org (Postfix) with ESMTP id E435E475809
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 16:51:52 -0400 (EDT)
Received: from [152.3.11.193] (bglab2.botany.duke.edu [152.3.11.193])
	by wilson.acpub.duke.edu (8.12.4/8.12.4/Duke-5.0.0) with ESMTP id
	g76KpkEc009696; Tue, 6 Aug 2002 16:51:50 -0400 (EDT)
Mime-Version: 1.0
X-Sender: chauser@mail-ch.acpub.duke.edu
Message-Id: <a05111b03b975e0252d02@[152.3.11.193]>
In-Reply-To: <200208061135.20799.josh@agliodbs.com>
References: <web-1602018@davinci.ethosmedia.com>
	<20611.1028651144@sss.pgh.pa.us> <200208061135.20799.josh@agliodbs.com>
Date: Tue, 6 Aug 2002 16:53:24 -0400
To: josh@agliodbs.com
From: Charles Hauser <chauser@duke.edu>
Subject: Re: problem fetching currval of sequence
Cc: pgsql-sql@postgresql.org, tgl@sss.pgh.pa.us
Content-Type: multipart/alternative;
	boundary="============_-1183455277==_ma============"
X-Virus-Scanned: by amavisd-milter, Duke University (http://amavis.org/)
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/117
X-Sequence-Number: 8963

--============_-1183455277==_ma============
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

Josh and Tom,

I have checked for typos, rewritten a smaller script and checked the 
table setup (\d gb, see below) and
	$result = $conn->exec(
			"SELECT currval('gb_gb_id_seq');"
			  );

continues to return the error:

	ERROR:  gb_gb_id_seq.currval is not yet defined in this session

I know this script worked in the past, but I have not used it 
recently.  We are running PostgreSQL 7.1.3.  It would be great if 
this would work as I have several scripts which operate in a similar 
manner for different TABLES, but if it won't work I'll work around it.

Suggestions for the best way to get the value for the gb_id after an INSERT?



chlamy_est=> \d gb
                                       Table "gb"
  Attribute |         Type          | 
Modifier                    
-----------+-----------------------+--------------------------------------------------
  gb_id     | integer               | not null default 
nextval('"gb_gb_id_seq"'::text)
  clone_id  | integer               |
  accn      | character varying(12) | not null
  gi        | integer               | not null
Index: gb_pkey

Hmm, that sure looks like it should work.  I can only counsel looking
for silly errors (typos, not running the same copy of the script that you
edited, etc).  Also double-check that gb.gb_id has the column default
nextval('gb_gb_id_seq')  (try psql's "\d gb" command).


-- 
Regards,

	Chuck
--============_-1183455277==_ma============
Content-Type: text/html; charset="us-ascii"

<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type="text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
 --></style><title>Re: [SQL] problem fetching currval of
sequence</title></head><body>
<div><tt>Josh and Tom,</tt></div>
<div><tt><br></tt></div>
<div><tt>I have checked for typos, rewritten a smaller script and
checked the table setup (\d gb, see below) and</tt></div>
<div><tt><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab></tt>$result = $conn-&gt;exec(</div>
<div><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab>&quot;SELECT currval('gb_gb_id_seq');&quot;</div>
<div><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </x-tab>&nbsp;
);</div>
<div><tt><br></tt></div>
<div><tt>continues to return the error:</tt></div>
<div><tt><br></tt></div>
<div><tt><font
color="#000000"><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</x-tab>ERROR:&nbsp; gb_gb_id_seq.currval is not yet defined in this
session</font></tt></div>
<div><tt><br></tt></div>
<div><tt>I know this script worked in the past, but I have not used it
recently.&nbsp; We are running</tt> PostgreSQL 7.1.3.&nbsp; It would
be great if this would work as I have several scripts which operate in
a similar manner for different TABLES, but if it won't work I'll work
around it.</div>
<div><br></div>
<div>Suggestions for the best way to get the value for the gb_id after
an INSERT?</div>
<div><br></div>
<div><br></div>
<div><font face="Courier" color="#000000"><br></font></div>
<div><font face="Courier" color="#000000">chlamy_est=&gt; \d gb<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span
>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span
>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span>&nbsp;&nbsp;&nbsp;&nbsp; Table &quot;gb&quot;<br>
&nbsp;Attribute |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Modifier&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br
>
-----------+-----------------------+---------------------------------<span
></span>-----------------<br>
&nbsp;gb_id&nbsp;&nbsp;&nbsp;&nbsp; |
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span>&nbsp;&nbsp;&nbsp;&nbsp; | not null default
nextval('&quot;gb_gb_id_seq&quot;'::text)<br>
&nbsp;clone_id&nbsp; |
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span>&nbsp;&nbsp;&nbsp;&nbsp; |<br>
&nbsp;accn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | character varying(12) | not
null<br>
&nbsp;gi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
></span>&nbsp;&nbsp;&nbsp;&nbsp; | not null<br>
Index: gb_pkey</font><br>
</div>
<div><font face="Courier">Hmm, that sure looks like it should work.&nbsp;
I can only counsel looking<br>
for silly errors (typos, not running the same copy of the script that
you</font></div>
<div><font face="Courier">edited, etc).&nbsp; Also double-check that
gb.gb_id has the column default</font></div>
<div><font face="Courier">nextval('gb_gb_id_seq')&nbsp; (try psql's
&quot;\d gb&quot; command).</font></div>
<div><font face="Courier"><br></font></div>
<div><br></div>
<x-sigsep><pre>-- 
</pre></x-sigsep>
<div>Regards,<br>
<br>
<x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </x-tab>Chuck</div>
</body>
</html>
--============_-1183455277==_ma============--