Re: [BUGS] BUG #2856: Jdbc 4 connector running on JDK 1.6 should

[Kris Jurka]

On Fri, 22 Dec 2006, Steve Langridge wrote:


Bug reference:  2856
PostgreSQL version: 8.2
Description:Jdbc 4 connector running on JDK 1.6 should not raise
exception for getClientInfo/setClientInfo
Details:

When using the Jdbc 4 driver running on Java 1.6, it would be preferable if
the methods getClientInfo() and setClientInfo() returned silently, instead
of raising an exception about not being implemented.  When running on
Glassfish with Toplink Essentials, the app server log gets filled with these
exceptions for every access from a JDBC connection pool (when using the
PGConnectionPoolDataSource).



I'm not sure it's legal to simply ignore the fact that the method is not 
implemented.  I think at minimum we'd need to keep the client info data in 
the Connection object even if we don't send it to the database.  This 
would make it look like it was working to the JVM there just wouldn't be a 
way to get at it on the database side.


Kris Jurka

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #2870: incorrect man page for postgres

[Dmitry D. Khlebnikov]

Euler,

On Wed, Jan 03, 2007 at 09:50:15PM -0200, Euler Taveira de Oliveira wrote:
 Dmitry D. Khlebnikov wrote:
 
  The man page for postgres(1) has a wrong description of the '-S' option. 
  Previously, the '-S' option means that postgres will start in the 'silent'
  mode, but in version 8.2 the '-S' option describes the amount of memory for
  sorts.
  
 I think you change the order, in 8.1 -S option describes the amount of
 memory but in 8.2 it describes the silent mode. This is because there

Perhaps.  However, when I tried to follow the man page and run
'postgres' with '-S' it responded with:

db!pgsql:~$ postgres --version
postgres (PostgreSQL) 8.2.0
db!pgsql:~$ postgres -D /var/lib/pgsql -S
postgres: option requires an argument -- S
Try postgres --help for more information.
db!pgsql:~$ postgres --help | fgrep -- -S
  -S WORK-MEM set amount of memory for sorts (in kB)
db!pgsql:~$ zcat /usr/share/man/man1/postgres.1.gz | fgrep -A 3 -- -S
\fB-S\fR
Specifies that the \fBpostgres\fR
process should start up in silent mode. That is, it will
disassociate from the user's (controlling) terminal, start its
db!pgsql:~$

All in all, I don't know how it was in the previous versions of
PostgreSQL (I was using 7.x versions), I just merely want to point out
that the man page provides the incorrect information wrt the '-S'
option.

-- 
(GM)


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match