[JDBC] DB Arrays in the JDBC driver

2001-02-12 Thread Michael Ansley
Title: DB Arrays in the JDBC driver Hi, all, Has anybody used the jdbc driver for any array handling, i.e.: with array columns defined on the database?  I have a particular set of tables that make use of a varchar array (_varchar), and jdbc does not handle this column.  Now, I know that the

Re: [JDBC] Xn block abort exceptions: BUG+PATCH

2001-02-12 Thread Peter T Mount
Quoting KB Sriram <[EMAIL PROTECTED]>: > I'm using the 7.0.3 release JDBC driver, and observed that when > Postgres aborts the transaction because of a problem within a > transaction block, SQLExceptions are not always thrown from the > driver on further queries within that block. > > For exampl

[JDBC] Status of JDBC web site

2001-02-12 Thread Peter T Mount
Before anyone else emails me saying that the links are broken, I know. I was in the middle of updating the site when I got interrupted, and haven't had chance to fix it yet (problem with a Dreamweaver template). It's doubtful I'll get chance to fix it before tomorrow (due to getting back from

[JDBC]

2001-02-12 Thread KB Sriram
I'm using the 7.0.3 release JDBC driver, and observed that when Postgres aborts the transaction because of a problem within a transaction block, SQLExceptions are not always thrown from the driver on further queries. To demonstrate this, say I have a table create table x (pk int4 primary key); N

Re: [JDBC]

2001-02-12 Thread Peter T Mount
Quoting KB Sriram <[EMAIL PROTECTED]>: > I'm using the 7.0.3 release JDBC driver, and observed that when > Postgres aborts the transaction because of a problem within a > transaction block, SQLExceptions are not always thrown from the > driver on further queries. [snip] > Looking into the code,

Re: [GENERAL] How to make PostgreSQL JDBC drive get PGTZ?

2001-02-12 Thread Barry Lind
What version of the database and jdbc driver are you using? This should be fixed and work correctly in current sources. thanks, --Barry Raymond Chui wrote: > My system time zone (TZ) is set to US Eastern Standard Time is -5 hours > of > GMT time > > I set > export PGTZ=GMT > then go to psql