FW: [GENERAL] Postgres 8.1 sequences and 'CALL'-syntax

2006-04-27 Thread Schnabl, Sebastian
> 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 wit

Re: [GENERAL] Postgres 8.1 sequences and 'CALL'-syntax

2006-04-27 Thread Kris Jurka
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 th

[GENERAL] Postgres 8.1 sequences and 'CALL'-syntax

2006-04-27 Thread Schnabl, Sebastian
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 next

Re: [GENERAL] Postgres 8.1 for Mac

2006-02-05 Thread Brendan Duddridge
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.

Re: [GENERAL] Postgres 8.1 for Mac

2006-02-01 Thread Vivek Khera
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 a

Re: [GENERAL] Postgres 8.1 for Mac

2006-01-31 Thread Jim C. Nasby
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.ne

Re: [GENERAL] Postgres 8.1 for Mac

2006-01-31 Thread Benjamin Reed
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 stil

Re: [GENERAL] Postgres 8.1 for Mac

2006-01-31 Thread Rick Gigger
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

Re: [GENERAL] Postgres 8.1 for Mac

2006-01-31 Thread Gavin M. Roy
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 i

Re: [GENERAL] Postgres 8.1 for Mac

2006-01-31 Thread Jonel Rienton
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

[GENERAL] Postgres 8.1 for Mac

2006-01-31 Thread Andrus
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)--

Re: [GENERAL] postgres 8.1 compile error in the pg_attribute.h file

2005-11-11 Thread Tom Lane
"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 CATA

[GENERAL] postgres 8.1 compile error in the pg_attribute.h file

2005-11-11 Thread Prasad Duggineni
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 me to fix this problem.     /usr/include/pgsql/server/catalog/pg_attribute.h:44:26: macro "CATALOG" passed 2

Re: [GENERAL] Postgres 8.1

2005-06-12 Thread Bruno Wolff III
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

[GENERAL] Postgres 8.1

2005-06-12 Thread Simon Windsor
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