Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Tom Lane
consistent ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [JDBC] Ant installation (and other) issues!

2001-10-22 Thread Tom Lane
not an acceptable amount of overhead to add to the Postgres distribution. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere

Re: [HACKERS] [JDBC] NULLs and sort order

2001-09-15 Thread Tom Lane
explicit sorts act the same as indexscans already did. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [JDBC] DatabaseMetadata problems

2001-09-07 Thread Tom Lane
. When is eventually? Possibly 7.3, but I can't promise anything... regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-06 Thread Tom Lane
? That seems to have been rather buggy. You might want to grab the latest version of the driver (I forget the URL but it's been mentioned repeatedly on this list). regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all

Re: [Fwd: Re: [JDBC] Using char fields with 7.1.3 driver]

2001-09-06 Thread Tom Lane
an ending space in a field, In varchar or text fields, trailing spaces are real data. In fixed-width char fields, trailing spaces are pads. AFAIK this is consistent with the SQL92 specification. regards, tom lane ---(end of broadcast

[JDBC] JDBC patch procedures (Re: [PATCHES] Patch for jdbc2 ResultSet.java)

2001-09-05 Thread Tom Lane
, volunteers? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [JDBC] driver source code indentation

2001-09-04 Thread Tom Lane
haven't been able to obtain any significant consensus for that view. Some developers apparently use editors where a physical tab character needs to equal the logical indent amount... regards, tom lane ---(end of broadcast

Re: [JDBC] Read transactions don't work on 7.0.x db's

2001-09-03 Thread Tom Lane
that will break backward compatibility to 7.0 servers anyway, I'm unconvinced that we need this at all. Perhaps a discussion about the costs and benefits of backwards compatibility in the JDBC driver is needed --- what tradeoffs do people want to make? regards, tom lane

Re: [JDBC] Fastpath error on solaris 2.8 pgsql 7.1.3

2001-08-27 Thread Tom Lane
that some of your application control paths have the BEGIN and some don't. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [JDBC] JDBC changes for 7.2... some questions...

2001-08-21 Thread Tom Lane
it for 7.2, but I'm still open to doing it in 7.3 if we can come up with a bulletproof spec. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [JDBC] JDBC changes for 7.2... some questions...

2001-08-21 Thread Tom Lane
. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [JDBC] Couple of patches for jdbc driver

2001-08-21 Thread Tom Lane
that that wasn't working too well. Anyone recall the reasons we pulled it into the main CVS tree? Wouldn't do to make the same mistakes twice... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [JDBC] JDBC pg_description update needed for CVS tip

2001-08-12 Thread Tom Lane
the behavior then we can reconsider it --- but if it's per spec then I think we should be happy. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge

Re: [JDBC] Large Objects

2001-07-29 Thread Tom Lane
that having done conn.setAutoCommit(false), you need to add a command to explicitly commit the transaction, but I don't know JDBC well enough to know how you do that... regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill

Re: [JDBC] Connection.setCatalog()

2001-07-17 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: Peter E. has previously commented that Postgres databases correspond most closely to the SQL concept of catalog cluster, not catalog. I most certainly did not. According to my interpretation: I sit corrected. If you want

Re: [JDBC] unlink large objects

2001-06-08 Thread Tom Lane
it? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [JDBC] Password authentication failure

2001-06-05 Thread Tom Lane
? Are you volunteering? There have been a couple of long discussions on pghackers about a better password challenge protocol. IIRC we came up with a good-looking paper design, but there was a notable lack of effort on actually making it happen. regards, tom lane

Re: [JDBC] Displaying/Pulling Images using JDBC ...

2001-05-12 Thread Tom Lane
nulls would be the likely cause of trouble. If you're seeing OIDs in the database then the actual storage is presumably in large objects. lo_read and friends are null-safe as far as I know; probably the problem is somewhere inside the JDBC driver. regards, tom lane

Re: [JDBC] Re: [HACKERS] Outstanding patches

2001-05-10 Thread Tom Lane
;-) Bruce did not have that patch on his list of things-to-apply, so either it was never properly submitted or it slipped through the cracks. Anyone want to dig it up and verify it against 7.1? regards, tom lane ---(end of broadcast

Re: [JDBC] Re: [HACKERS] Outstanding patches

2001-05-10 Thread Tom Lane
to be sufficient. Otherwise I think the patch is probably OK. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [JDBC] 'current' timestamp chokes jdbc driver

2001-05-07 Thread Tom Lane
undocumented). So I'm not sure it's worth hacking JDBC to deal with it... regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

MULTIBYTE and SQL_ASCII (was Re: [JDBC] Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?)

2001-05-05 Thread Tom Lane
. To my mind, a MULTIBYTE backend operating in SQL_ASCII encoding ought to behave the same as a non-MULTIBYTE backend: transparent pass-through of characters with the high bit set. But I'm not a multibyte guru. Comments anyone? regards, tom lane ---(end

Re: [JDBC] Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?

2001-05-04 Thread Tom Lane
puts up with the overhead of MULTIBYTE support. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [JDBC] Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?

2001-05-04 Thread Tom Lane
. Or so I would think, anyway. I have to admit I have not looked very closely at the functionality that's enabled by MULTIBYTE; is any of it really needed to deal with LATINn character sets? regards, tom lane ---(end of broadcast

Re: [JDBC] Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?

2001-05-04 Thread Tom Lane
their lives worse, or even different? I'm merely suggesting that the default behavior could be made useful to a larger set of people than it now is, without making things any worse for those that it's not useful to. regards, tom lane ---(end of broadcast

Re: [JDBC] Unable to store SHA hash (Non-HTML--Sorry)

2001-05-02 Thread Tom Lane
what command is arriving at the backend when you try to insert this data. That should determine whether the client or server side is at fault. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet