Re: [SQL] [JDBC] Calling a table in another database from plpgsql

a recent off-topic question from him which I responded to with an answer and a suggestion of the appropriate list. As long as answers keep coming the hint will not be picked up. Kris Jurka ---(end of broadcast)--- TIP 2: you can get off all lis

Re: [SQL] org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)

eveal anything you might try upgrading the JDBC driver to a later version. Kris Jurka ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] [JDBC] Error in DatabaseMetaData.getColumns() with Views

ATER VIEW v AS SELECT (a+b)::numeric(6,2) FROM tab; Kris Jurka ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [SQL] [JDBC] Prepare Statement

a known issue. It's on the list. Kris Jurka ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] [JDBC] Prepare Statement

be found, but remember the premature optimization adage. > > Secondly, I assume the function should be a pre-compiled object stored > on server side, doesn't it. > I depends on the language the function is written. plpgsql caches plans, but not all procedural

Re: [SQL] [JDBC] Prepare Statement

gh it doesn't use a server prepared statement, and as I mentioned earlier the performance improvement if any will be minimal. Have you done any testing to show that you are even getting a performance gain? Kris Jurka ---(end of broadcast)--

Re: [SQL] [JDBC] Prepare Statement

at with a callable statement it is examinging the query with "call" before it is transformed to a SELECT, so it doesn't recognize it as a preparable. This looks like a bug to me. Kris Jurka ---(end of broadcast)--- TIP 3: if po

Re: [SQL] [JDBC] Prepare Statement

not one of unknown type. Ideally you should be using setArray, but there is no existing way to create Array objects and I'm not sure that code would work even if there was. Kris Jurka ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] [JDBC] Prepare Statement

7;t know why this would be different for you. What exact version of the server and driver are you using? Kris Jurka ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] [JDBC] Prepare Statement

ample because this functionality is undocumented in the released version. In the 7.4 version the enabling of server side statements is only possible via a boolean flag at the statement level, namely PGStatement.setUseServerPrepare(true); Kris Jurka ---(end of broadca

Re: [SQL] [JDBC] Prepare Statement

ch09s05.html Soon to be committed cvs version: can directly use server prepared statements without using the SQL level PREPARE/EXECUTE. Kris Jurka ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-

Re: [SQL] MINUS & ROWNUM in PostGres

been suggested that ROWNUM could be replaced by the nextval of a temporary sequence. Kris Jurka ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]