Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7E9A69FA2FD for ; Tue, 22 May 2007 04:43:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66881-10 for ; Tue, 22 May 2007 04:43:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 118A29FA31A for ; Tue, 22 May 2007 04:43:44 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HqP1t-0006Yn-3I for pgsql-sql@postgresql.org; Tue, 22 May 2007 09:43:37 +0200 Received: from pc035-72.amg.gda.pl ([153.19.72.35]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 22 May 2007 09:43:37 +0200 Received: from mstepnicki by pc035-72.amg.gda.pl with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 22 May 2007 09:43:37 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: =?iso-8859-2?q?Marcin_St=EApnicki?= Subject: Re: system table storing sequence attributes Date: Tue, 22 May 2007 09:43:23 +0200 Organization: Linux.PL Lines: 18 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pc035-72.amg.gda.pl User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table (Debian GNU/Linux)) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/151 X-Sequence-Number: 28431 Dnia Tue, 22 May 2007 10:03:28 +0300, Sabin Coanda napisał(a): > Hi there, > > I'd like to read the global sequence attribute "currval", but not using > currval function, because it is session dependent and requires a nextval > function to be used before. > > Do you know where is stored this value in the system tables ? select last_value from sequence_name -- | And Do What You Will be the challenge | http://apcoln.linuxpl.org | So be it in love that harms none | http://biznes.linux.pl | For this is the only commandment. | http://www.juanperon.info `---* JID: Aragorn_Vime@jabber.org *---' http://www.naszedzieci.org