pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 8.1 sequences and 'CALL'-syntax
2+ messages / 2 participants
[nested] [flat]
* Postgres 8.1 sequences and 'CALL'-syntax
@ 2006-04-27 07:34 Schnabl, Sebastian <s.schnabl@qualitype.de>
2006-05-08 21:23 ` Re: Postgres 8.1 sequences and 'CALL'-syntax Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Schnabl, Sebastian @ 2006-04-27 07:34 UTC (permalink / raw)
To: pgsql-sql
Hello,
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')".
But unfortunately i always get only an syntax error on "call" from jdbc-driver or specially postgres as result.
How can i use sequences in conjunction with "call"-syntax??
Thx in advance
______________________________________________________________
Sebastian Schnabl
Qualitype AG
Quality Assurance Systems |Bioinformatics
Moritzburger Weg 67 | 01109 Dresden
fon +49.351.8838 0 | fax +49.351.8838 2809
http://www.qualitype.de
______________________________________________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres 8.1 sequences and 'CALL'-syntax
2006-04-27 07:34 Postgres 8.1 sequences and 'CALL'-syntax Schnabl, Sebastian <s.schnabl@qualitype.de>
@ 2006-05-08 21:23 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2006-05-08 21:23 UTC (permalink / raw)
To: pgsql-sql; +Cc: Schnabl, Sebastian <s.schnabl@qualitype.de>
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-05-08 21:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-27 07:34 Postgres 8.1 sequences and 'CALL'-syntax Schnabl, Sebastian <s.schnabl@qualitype.de>
2006-05-08 21:23 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox