[BUGS] BUG #4956: Array Construct array() returning blank result

2009-07-31 Thread Niranjan Pandit
The following bug has been logged online: Bug reference: 4956 Logged by: Niranjan Pandit Email address: niranja...@gmail.com PostgreSQL version: 8.4 Operating system: Windows Vista Ultimate Description:Array Construct array() returning blank result Details: Hi, I si

[BUGS] BUG #4957: search_path and pg_dump -T switch

2009-07-31 Thread Maxim.Boguk
The following bug has been logged online: Bug reference: 4957 Logged by: Maxim.Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 8.3 Operating system: Any Description:search_path and pg_dump -T switch Details: If table lies outside of database search pa

Re: [BUGS] BUG #4957: search_path and pg_dump -T switch

2009-07-31 Thread Tom Lane
"Maxim.Boguk" writes: > Now we have table test1 with one row outside of search_path and table test2 > with one row inside of search path. > Now > pg_dump -F p -D -T test1 -a test_db | grep test1 > will out: > INSERT INTO test1 (id) VALUES (1); > And > pg_dump -F p -D -T test2 -a test_db | grep

Re: [BUGS] BUG #4956: Array Construct array() returning blank result

2009-07-31 Thread Tom Lane
"Niranjan Pandit" writes: > Only when the condition gets evaluated to true with at least 2 columns with > varying values the array gets constructed, in all other cases what we get is > a complete blank output. the label of the result is as usual as ?column? but > there is absolutely nothing in the

[BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-07-31 Thread Luke Koops
The following bug has been logged online: Bug reference: 4958 Logged by: Luke Koops Email address: luke.ko...@entrust.com PostgreSQL version: 8.3.7 Operating system: Windows 2003 EE SP2 Description:Stats collector hung on WaitForMultipleObjectsEx while attempting to r

[BUGS] Inconsistent query results after upgrading to Postgresql 8.4.0

2009-07-31 Thread Ryan Wallace
Your name: Nicholas Jakobsen, Ryan Wallace Your email address: nicholas.jakob...@telus.net, ryw...@gmail.com System Configuration: -   Architecture (example: Intel Pentium): Intel Core 2 Duo   Operating System (example: Linux 2.4.18): OS X 10.5 (Leopard)   PostgreSQL version

[BUGS] BUG #4959: unable to install/start service

2009-07-31 Thread
The following bug has been logged online: Bug reference: 4959 Logged by: Email address: wad...@jcom.home.ne.jp PostgreSQL version: 8.4.0 Operating system: Windows Description:unable to install/start service Details: If service account password contains '>', install

Re: [BUGS] Inconsistent query results after upgrading to Postgresql 8.4.0

2009-07-31 Thread Tom Lane
Ryan Wallace writes: > Query returns incorrect results when executed on PostgreSQL 8.4.0. The > same query was executed successfully on PostgreSQL 8.3.7. There have been some fixes in the semijoin-planning code since 8.4.0. Would you try your test case against a CVS pull or nightly snapshot?

[BUGS] BUG #4960: Unexpected timestamp rounding

2009-07-31 Thread Matthias
The following bug has been logged online: Bug reference: 4960 Logged by: Matthias Email address: matthias.ce...@gmail.com PostgreSQL version: 8.3.7 Operating system: Windows XP Description:Unexpected timestamp rounding Details: Dear developers, I noticed an unusual

Re: [BUGS] BUG #4960: Unexpected timestamp rounding

2009-07-31 Thread Kevin Grittner
"Matthias" wrote: > I noticed an unusual (and from my point of view inconsistent) > rounding of a timestamp: What do you get when you run?: show integer_datetimes; If it is off, which is probably the default for your distribution under 8.3.X, timestamps are floating point (approximate) val

Re: [BUGS] BUG #4960: Unexpected timestamp rounding

2009-07-31 Thread Kevin Grittner
"Matthias" wrote: > It is about when using a upper-boundary timestamp. The value of > -12-31 23:59:59.99 is sometimes used to indicate an infinite > validity. One other thought -- using a "magic value" for something like this is usually a bad idea. NULL indicates the absence of a valu

Re: [BUGS] BUG #4960: Unexpected timestamp rounding

2009-07-31 Thread Tom Lane
"Kevin Grittner" writes: > "Matthias" wrote: >> It is about when using a upper-boundary timestamp. The value of >> -12-31 23:59:59.99 is sometimes used to indicate an infinite >> validity. > One other thought -- using a "magic value" for something like this is > usually a bad idea. NUL

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-07-31 Thread Alvaro Herrera
Luke Koops wrote: > Description:Stats collector hung on WaitForMultipleObjectsEx while > attempting to recv a datagram > Details: > > While running a load test with 80 processes connected to postgres, of which > 62 were generating load, the stats collector got blocked on > WaitForMultipl