[BUGS] Postgres Server Jdbc driver error

2011-08-04 Thread Silvio Brandani
We get error with the following query where the paramater is 'att', the query return result if the parameter is different than 'att'. Probably a bug. the postgresql log is: 2011-08-04 10:44:56 CEST [28741]: [59238-1] LOG: execute S_1: BEGIN 2011-08-04 10:44:56 CEST [28741]: [59239-1] LOG: dura

Re: [BUGS] [JDBC] Postgres Server Jdbc driver error

2011-08-04 Thread Oliver Jowett
2011/8/4 Silvio Brandani : > On the Tomcat side we get followin message: > > > Caused by: java.io.IOException: Tried to send an out-of-range integer as a > 2-byte value: 34027 > at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201) > at > org.postgresql.core.v3.QueryExecutorImpl.sendPars

Re: [BUGS] [JDBC] Postgres Server Jdbc driver error

2011-08-04 Thread Silvio Brandani
Il 04/08/2011 13.00, Oliver Jowett ha scritto: 2011/8/4 Silvio Brandani: On the Tomcat side we get followin message: Caused by: java.io.IOException: Tried to send an out-of-range integer as a 2-byte value: 34027 at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201) at org.postgresql

[BUGS] BUG #6147: Changing search_path between invocations of a function ignored by 2nd invocation of function

2011-08-04 Thread Jim McQuillan
The following bug has been logged online: Bug reference: 6147 Logged by: Jim McQuillan Email address: j...@avairis.com PostgreSQL version: 9.0.4 Operating system: Ubuntu 10.04 x86 32 and 64 bit Description:Changing search_path between invocations of a function ignored

[BUGS] Re: BUG #6120: Problem running post-install step in Mac OS X Lion (GM)

2011-08-04 Thread simonrodan
I have worked around this by adding the postgres user by hand: sudo dscl . -create /users/postgres sudo mkdir -p /usr/local/pgsql/data sudo chown postgres /usr/local/pgsql/data sudo dscl . -passwd /users/postgres su postgres chmod 755 /Library/PostgreSQL/9.0/bin/initdb su postgres /Library/Postgr

[BUGS] BUG #6148: unterminated CSV quoted field

2011-08-04 Thread william wei
The following bug has been logged online: Bug reference: 6148 Logged by: william wei Email address: wei_jie...@founder.com PostgreSQL version: 8 Operating system: linux Description:unterminated CSV quoted field Details: error: unterminated CSV quoted field. when imp

[BUGS] Re: BUG #6120: Problem running post-install step in Mac OS X Lion (GM)

2011-08-04 Thread blammo72
Thanks for the help with the adding the user... When I try to set up a new server with pgAdmin3 I get the message "Postgres not listening". What are the next steps to get Postgresql running a database? We at our firm never expected that postgresql installer would be deprecated this long --

[BUGS] BUG #6149: My table is empty but pg_relation_size(name) returns 39 MB

2011-08-04 Thread Shivakumar Ramannavar
The following bug has been logged online: Bug reference: 6149 Logged by: Shivakumar Ramannavar Email address: shiv...@gmail.com PostgreSQL version: 9.0.4 Operating system: open SUSE Linux Description:My table is empty but pg_relation_size(name) returns 39 MB Details:

Re: [BUGS] BUG #6149: My table is empty but pg_relation_size(name) returns 39 MB

2011-08-04 Thread Kevin Grittner
"Shivakumar Ramannavar" wrote: > Though my table is empty, pg_relation_size(name) return 38 MB. This is unlikely to be a bug, although without more information it's hard to be sure. Please post any follow-ups on the identical post you put on another list. And please don't cross-post like tha

[BUGS] BUG #6150: commit_delay should have unit ms

2011-08-04 Thread Christoph Anton Mitterer
The following bug has been logged online: Bug reference: 6150 Logged by: Christoph Anton Mitterer Email address: cales...@scientia.net PostgreSQL version: 0.9 Operating system: Debian sid Description:commit_delay should have unit ms Details: Hi. AFAIK form the docu

[BUGS] BUG #6151: documentation claims that default value for log_timezone is "unknown"

2011-08-04 Thread Christoph Anton Mitterer
The following bug has been logged online: Bug reference: 6151 Logged by: Christoph Anton Mitterer Email address: cales...@scientia.net PostgreSQL version: 9.0 Operating system: Debian sid Description:documentation claims that default value for log_timezone is "unknown

Re: [BUGS] BUG #6151: documentation claims that default value for log_timezone is "unknown"

2011-08-04 Thread Tom Lane
"Christoph Anton Mitterer" writes: > The documentation tells > (http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html#GUC-L > OG-TIMEZONE) that the default for log_timezone is "unknown". That is technically correct, if not terribly helpful, in existing releases. 9.1 will be a bit