X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B25439F931D for ; Mon, 8 May 2006 18:24:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 95065-06-2 for ; Mon, 8 May 2006 18:23:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 189E19F931E for ; Mon, 8 May 2006 18:23:57 -0300 (ADT) Received: (qmail invoked by alias); 08 May 2006 21:23:56 -0000 Received: from dslb-084-063-047-013.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.47.13] by mail.gmx.net (mp018) with SMTP; 08 May 2006 23:23:56 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-sql@postgresql.org Subject: Re: Postgres 8.1 sequences and 'CALL'-syntax Date: Mon, 8 May 2006 23:23:54 +0200 User-Agent: KMail/1.8.3 Cc: "Schnabl, Sebastian" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200605082323.55081.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/82 X-Sequence-Number: 25113 Schnabl, Sebastian wrote: > I use postgres 8.1 and trie to run jboss over sequoia-ha > (http://sequoia.continuent.org/HomePage). But i have an problem with > sequences. Sequoia claims to support for good reasons and > db-independece only "sql-standard(s)". Therefore they DON'T support > the postgres-specific "select nextval('seq_name')". Instead they gave > me the hint to use the sql-conform "call nexval('seq_name')". That statement is not any more SQL conforming than the other. -- Peter Eisentraut http://developer.postgresql.org/~petere/