[GENERAL] Postgres 8.1 sequences and 'CALL'-syntax
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
__
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: [GENERAL] Postgres 8.1 sequences and 'CALL'-syntax
On Thu, 27 Apr 2006, Schnabl, Sebastian wrote:
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').
I'm not sure where they layer their stuff on, but the pg jdbc driver will
support something like the following:
Connection conn = ...
CallableStatement cs = conn.prepareCall({? = call nextval('seq_nm')});
cs.registerOutParameter(1, Types.BIGINT);
cs.execute();
long nextval = cs.getLong(1);
cs.close();
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
FW: [GENERAL] Postgres 8.1 sequences and 'CALL'-syntax
Connection conn = ...
CallableStatement cs = conn.prepareCall({? = call
nextval('seq_nm')}); cs.registerOutParameter(1, Types.BIGINT);
cs.execute(); long nextval = cs.getLong(1); cs.close();
Yeah, it seems to work, if i change the definition for calling the sequence in
conjunction with sequoia trough jboss change into: {call
nextvalue('seq_name')} [the {} pair is important !] and use the
org.postgresql.jdbc3.Jdbc3PooledDataSource driver class.
Many Thx !
---(end of broadcast)---
TIP 6: explain analyze is your friend
Re: [GENERAL] Postgres 8.1 for Mac
We use the instructions at http://www.keyvaluecoding.com Works great. Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Feb 1, 2006, at 2:15 PM, Vivek Khera wrote: On Jan 31, 2006, at 4:57 PM, Jim C. Nasby wrote: There's also darwinports, which has 8.1.2. but does some idiotic bizarre weird strange install of the binaries into /opt/local/lib/pgsql8/bin/ and symlinks the psql program as psql8 into your normal bin directory. it is just painful to administer a pg server with that install (unless you add the path to your bin, which I hate to have to do for each and every app installed -- this aint windows!!!) smime.p7s Description: S/MIME cryptographic signature
Re: [GENERAL] Postgres 8.1 for Mac
On Jan 31, 2006, at 4:57 PM, Jim C. Nasby wrote: There's also darwinports, which has 8.1.2. but does some idiotic bizarre weird strange install of the binaries into /opt/local/lib/pgsql8/bin/ and symlinks the psql program as psql8 into your normal bin directory. it is just painful to administer a pg server with that install (unless you add the path to your bin, which I hate to have to do for each and every app installed -- this aint windows!!!) smime.p7s Description: S/MIME cryptographic signature
[GENERAL] Postgres 8.1 for Mac
How to install Postgres 8.1 on PowerMac 10.1, OS X 10.4.4 ? Is there ready made binaries available for download of should I build from source ? Where are installing or building instructions for Mac available ? Andrus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Postgres 8.1 for Mac
Initial setup, I used the packages at http://www.entropy.ch and from that point on, I build from source for the upgrades. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrus Sent: Tuesday, January 31, 2006 9:59 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Postgres 8.1 for Mac How to install Postgres 8.1 on PowerMac 10.1, OS X 10.4.4 ? Is there ready made binaries available for download of should I build from source ? Where are installing or building instructions for Mac available ? Andrus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.25/246 - Release Date: 1/30/2006 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Postgres 8.1 for Mac
I haven't compiled it myself, but a guess would be if you installed XCode (which comes with gcc, and should have most if not all the libs needed) it's a matter of grabbing the source, untarring it, running ./ configure in the src dir, make, and make install, etc. (Follow the normal build instructions) Good luck! Gavin On Jan 31, 2006, at 7:58 AM, Andrus wrote: How to install Postgres 8.1 on PowerMac 10.1, OS X 10.4.4 ? Is there ready made binaries available for download of should I build from source ? Where are installing or building instructions for Mac available ? Andrus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Postgres 8.1 for Mac
I haven't tried those specific versions but I'm guessing a build from source will work great. If you are ok with just using 8.0 then you could use fink (http:// fink.sourceforge.net). Fink is apt-get for Mac. It looks like 8.1 is still in their unstable branch. Hopefully it will be moved to stable soon. Rick On Jan 31, 2006, at 8:58 AM, Andrus wrote: How to install Postgres 8.1 on PowerMac 10.1, OS X 10.4.4 ? Is there ready made binaries available for download of should I build from source ? Where are installing or building instructions for Mac available ? Andrus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Postgres 8.1 for Mac
On 1/31/06, Rick Gigger [EMAIL PROTECTED] wrote: I haven't tried those specific versions but I'm guessing a build from source will work great. If you are ok with just using 8.0 then you could use fink (http:// fink.sourceforge.net). Fink is apt-get for Mac. It looks like 8.1 is still in their unstable branch. Hopefully it will be moved to stable soon. yeah, they should be moved to stable shortly, I've got another rev I want to put out with some other administrative/documentation updates in the package descriptions, and then, barring issues, I'll put that out. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Postgres 8.1 for Mac
There's also darwinports, which has 8.1.2. On Tue, Jan 31, 2006 at 09:44:13AM -0700, Rick Gigger wrote: I haven't tried those specific versions but I'm guessing a build from source will work great. If you are ok with just using 8.0 then you could use fink (http:// fink.sourceforge.net). Fink is apt-get for Mac. It looks like 8.1 is still in their unstable branch. Hopefully it will be moved to stable soon. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] postgres 8.1 compile error in the pg_attribute.h file
I am getting the compile error in the
/usr/include/pgsql/server/catalog/pg_attribute.h after installing the
postgres8.1. I never had this problem for the postgres8.03 . please advice
meto fix this problem.
/usr/include/pgsql/server/catalog/pg_attribute.h:44:26: macro "CATALOG"
passed 2 arguments, but takes just 1In file included from
/usr/include/pgsql/server/access/tupdesc.h:18,
from
/usr/include/pgsql/server/utils/rel.h:17,
from
/usr/include/pgsql/server/storage/bufmgr.h:21,
from
/usr/include/pgsql/server/storage/bufpage.h:18,
from
/usr/include/pgsql/server/access/htup.h:17,
from
/usr/include/pgsql/server/executor/tuptable.h:17,
from phonelib.c:49:/usr/include/pgsql/server/catalog/pg_attribute.h:44:
error: syntax error before
"BKI_BOOTSTRAP"/usr/include/pgsql/server/catalog/pg_attribute.h:45: error:
syntax error before '{'
token/usr/include/pgsql/server/catalog/pg_attribute.h:152: error: syntax
error before '}' token/usr/include/pgsql/server/catalog/pg_attribute.h:152:
warning: type defaults to `int' in declaration of
`FormData_pg_attribute'/usr/include/pgsql/server/catalog/pg_attribute.h:152:
warning: data definition has no type or storage
class/usr/include/pgsql/server/catalog/pg_attribute.h:167: error: syntax
error before '*' token/usr/include/pgsql/server/catalog/pg_attribute.h:167:
warning: type defaults to `int' in declaration of
`Form_pg_attribute'/usr/include/pgsql/server/catalog/pg_attribute.h:167:
warning: data definition has no type or storage classIn file included from
/usr/include/pgsql/server/utils/rel.h:17,
from
/usr/include/pgsql/server/storage/bufmgr.h:21,
from
/usr/include/pgsql/server/storage/bufpage.h:18,
from
/usr/include/pgsql/server/access/htup.h:17,
from
/usr/include/pgsql/server/executor/tuptable.h:17,
from phonelib.c:49:/usr/include/pgsql/server/access/tupdesc.h:64: error:
syntax error before
"Form_pg_attribute"/usr/include/pgsql/server/access/tupdesc.h:64: warning:
no semicolon at end of struct or
union/usr/include/pgsql/server/access/tupdesc.h:70: error: syntax error
before '}' token/usr/include/pgsql/server/access/tupdesc.h:70: warning: type
defaults to `int' in declaration of
`TupleDesc'/usr/include/pgsql/server/access/tupdesc.h:70: warning: data
definition has no type or storage
class/usr/include/pgsql/server/access/tupdesc.h:73: error: syntax error
before
"CreateTemplateTupleDesc"/usr/include/pgsql/server/access/tupdesc.h:73:
warning: type defaults to `int' in declaration of
`CreateTemplateTupleDesc'/usr/include/pgsql/server/access/tupdesc.h:73:
warning: data definition has no type or storage
class/usr/include/pgsql/server/access/tupdesc.h:75: error: syntax error
before "CreateTupleDesc"/usr/include/pgsql/server/access/tupdesc.h:76:
error: syntax error before
"Form_pg_attribute"/usr/include/pgsql/server/access/tupdesc.h:76: warning:
type defaults to `int' in declaration of
`CreateTupleDesc'/usr/include/pgsql/server/access/tupdesc.h:76: warning:
data definition has no type or storage
class/usr/include/pgsql/server/access/tupdesc.h:78: error: syntax error
before "CreateTupleDescCopy"/usr/include/pgsql/server/access/tupdesc.h:78:
error: syntax error before
"tupdesc"/usr/include/pgsql/server/access/tupdesc.h:78: warning: type
defaults to `int' in declaration of
`CreateTupleDescCopy'/usr/include/pgsql/server/access/tupdesc.h:78: warning:
data definition has no type or storage
class/usr/include/pgsql/server/access/tupdesc.h:80: error: syntax error
before
"CreateTupleDescCopyConstr"/usr/include/pgsql/server/access/tupdesc.h:80:
error: syntax error before
"tupdesc"/usr/include/pgsql/server/access/tupdesc.h:80: warning: type
defaults to `int' in declaration of
`CreateTupleDescCopyConstr'/usr/include/pgsql/server/access/tupdesc.h:80:
warning: data definition has no type or storage
class/usr/include/pgsql/server/access/tupdesc.h:82: error: syntax error
before "tupdesc"/usr/include/pgsql/server/access/tupdesc.h:84: error: syntax
error before "tupdesc1"/usr/include/pgsql/server/access/tupdesc.h:86: error:
syntax error before "desc"/usr/include/pgsql/server/access/tupdesc.h:93:
error: syntax error before
"BuildDescForRelation"/usr/include/pgsql/server/access/tupdesc.h:93:
warning: type defaults to `int' in declaration of
`BuildDescForRelation'/usr/include/pgsql/server/access/tupdesc.h:93:
warning: data definition has no type or storage classIn file included from
/usr/include/pgsql/server/utils/rel.h:18,
from
/usr/include/pgsql/server/storage/bufmgr.h:21,
from
/usr/include/pgsql/server/storage/bufpage.h:18,
from
/usr/include/pgsql/server/access/htup.h:17,
from
/usr/include/pgsql/server/executor/tuptable.h:17,
from phonelib.c:49:/usr/include/pgsql/server/catalog/pg_am.h:39:19: macro
"CATALOG" passed 2 arguments, but takes just 1In file included from
/usr/include/pgsql/server/utils/rel.h:18,
from
/usr/include/pgsql/server/storage/bufmgr.h:21,
from
Re: [GENERAL] postgres 8.1 compile error in the pg_attribute.h file
Prasad Duggineni [EMAIL PROTECTED] writes: I am getting the compile error in the = /usr/include/pgsql/server/catalog/pg_attribute.h after installing the = postgres8.1. /usr/include/pgsql/server/catalog/pg_attribute.h:44:26: macro CATALOG = passed 2 arguments, but takes just 1 CATALOG() used to take 1 argument before 8.1, but now it takes 2. Apparently your compile is managing to include some unholy combination of 8.1 and pre-8.1 Postgres header files (specifically, it's picking up an obsolete copy of postgres.h from somewhere). Check include paths and so forth. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] Postgres 8.1
Hi Has a roadmap and timescale been released for Postgres 8.1? All the best Simon Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599
Re: [GENERAL] Postgres 8.1
On Sun, Jun 12, 2005 at 23:03:35 +0100, Simon Windsor [EMAIL PROTECTED] wrote: Has a roadmap and timescale been released for Postgres 8.1? Feature freeze will be July 1. Expect a beta about 1 month after that (based on past experience). The date of the release is highly variable, but will probably be around December. The TODO list has information on some things that have already been done. Other things are going on, but aren't written up anywhere. Reading through the hackers archives should give you some more information. Was there some particular feature you were interested in? ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
