Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Joshua D. Drake



We have had several customers get bit by the 8.2.3 stats collector bug.
It is also starting to get reported in areas such as IRC. The really bad
thing about this bug is that you won't know what is wrong unless you
know where to look, PostgreSQL will just appear slow and tying up 
resources.


I reiterate the question. Can we please package 8.2.4.

Joshua D. Drake


--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Peter Eisentraut
Am Montag, 26. März 2007 18:07 schrieb Joshua D. Drake:
 I reiterate the question. Can we please package 8.2.4.

Sure, go ahead.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Joshua D. Drake

Peter Eisentraut wrote:

Am Montag, 26. März 2007 18:07 schrieb Joshua D. Drake:

I reiterate the question. Can we please package 8.2.4.


Sure, go ahead.


Funny :). What can I do to help get 8.2.4 branched?

Joshua D. Drake




--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Peter Eisentraut
Joshua D. Drake wrote:
 Funny :). What can I do to help get 8.2.4 branched?

There is no branching involved, but you can look into 
src/tools/RELEASE_CHANGES and see what things you want to help with.  
Getting a release changes list would be a start.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Dave Page
Peter Eisentraut wrote:
 Joshua D. Drake wrote:
 Funny :). What can I do to help get 8.2.4 branched?
 
 There is no branching involved, but you can look into 
 src/tools/RELEASE_CHANGES and see what things you want to help with.  
 Getting a release changes list would be a start.
 

We're just starting to get the process nice and streamlined with all the
various binary builds, announcements and CVE embargos (when needed).
Perhaps it's not such a good idea to start reassigning tasks to random
people (no offence JD) without discussion and agreement from those
normally responsible?

Regards, Dave.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Joshua D. Drake

Dave Page wrote:

Peter Eisentraut wrote:

Joshua D. Drake wrote:

Funny :). What can I do to help get 8.2.4 branched?
There is no branching involved, but you can look into 
src/tools/RELEASE_CHANGES and see what things you want to help with.  
Getting a release changes list would be a start.




We're just starting to get the process nice and streamlined with all the
various binary builds, announcements and CVE embargos (when needed).
Perhaps it's not such a good idea to start reassigning tasks to random
people (no offence JD) without discussion and agreement from those
normally responsible?


No offense taken, I think Peter was saying... Hey this is something you 
(being me) could probably do, to help the continuation of that process. 
It is (i would guess) certainly something that people don't like doing 
in general and thus would help get the ball rolling.


I don't mind either way, but 8.2.4 needs to be released. If my putting 
together a changes list will help with that. I will do so.


Sincerely,

Joshua D. Drake




Regards, Dave.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org




--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Magnus Hagander
Joshua D. Drake wrote:
 Dave Page wrote:
 Peter Eisentraut wrote:
 Joshua D. Drake wrote:
 Funny :). What can I do to help get 8.2.4 branched?
 There is no branching involved, but you can look into
 src/tools/RELEASE_CHANGES and see what things you want to help with. 
 Getting a release changes list would be a start.


 We're just starting to get the process nice and streamlined with all the
 various binary builds, announcements and CVE embargos (when needed).
 Perhaps it's not such a good idea to start reassigning tasks to random
 people (no offence JD) without discussion and agreement from those
 normally responsible?
 
 No offense taken, I think Peter was saying... Hey this is something you
 (being me) could probably do, to help the continuation of that process.
 It is (i would guess) certainly something that people don't like doing
 in general and thus would help get the ball rolling.
 
 I don't mind either way, but 8.2.4 needs to be released. If my putting
 together a changes list will help with that. I will do so.

I would assume that would be a big help, especially given that Bruce is
busy with the patch queue right now.

There is another point to putting it out fairly soon - we're entering
feature freeze, and most devs would likely want to focus on 8.3 at that
time. Probably a good thing to get 8.2.4 out before that (which really
means we should've started a couple of weeks back, but hey, we can't
have everything)

//Magnus

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Dave Page
Joshua D. Drake wrote:
 Dave Page wrote:
 Peter Eisentraut wrote:
 Joshua D. Drake wrote:
 Funny :). What can I do to help get 8.2.4 branched?
 There is no branching involved, but you can look into
 src/tools/RELEASE_CHANGES and see what things you want to help with. 
 Getting a release changes list would be a start.


 We're just starting to get the process nice and streamlined with all the
 various binary builds, announcements and CVE embargos (when needed).
 Perhaps it's not such a good idea to start reassigning tasks to random
 people (no offence JD) without discussion and agreement from those
 normally responsible?
 
 No offense taken, I think Peter was saying... Hey this is something you
 (being me) could probably do, to help the continuation of that process.
 It is (i would guess) certainly something that people don't like doing
 in general and thus would help get the ball rolling.
 
 I don't mind either way, but 8.2.4 needs to be released. If my putting

Yeah, I know - we should just get agreement on such procedural changes
first imho.

/D

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Joshua D. Drake

Hello,

Below is the change log as I see it. I gleaned it from here:

http://projects.commandprompt.com/public/pgsql/log/branches/REL8_2_STABLE

If I missed anything let me know.

Sincerely,

Joshua D. Drake


* Fixed preload_shared_libraries on Windows (Bruce)

* Rearrange use of plpgsql_add_initdatums() so that only the parsing of 
a DECLARE section needs to know about it. Fixes bug that caused a 
DECLARE within an exception handler tried to reinitialize SQLERRM. (Tom)


* Fixed an ancient local varaiable (re)initializing  error in plpgsql's 
exec_stmt_block. (Tom)


* Fixed bug when localized to_char() day or month names were incorrectly
transformed to lower or upper string. (Bruce)

*  Fix for early log messages getting lost on postmaster startup when
running as a service on Win32. (Magnus)

* Fixed backend crash with incorrect ts_query (tsearch2) parsing. (Teodor)

* Fixed bug in JOIN logic for planning OUTER JOINS. (Tom)

* Disallow commiting prepared transactions from a different database in 
which the transaction was initiated (Heikki)


* Improve handling of psuedoconstants (Tom)

* Resolved bug with clauseless JOINS and subqueries. (Tom)

* Fixed problem in 8.2 changes that allowed one-time qual conditions 
to be checked at plan levels below the top. (Tom)


* Adjust is_pushed_down to work correctly with INNER JOINS. (Tom)

* Fixed old bug in portal management for FETCH queries. (Tom)

* Allow Win32 pg_dump to create files larger than 2GB (Magnus)

* Made markQueryForLocking() work with nested views. (Tom)

* Fix miscalculation of stats collector's write delay. (Tom)

* Fix inline_function() to work with binary compatible cases. (Tom)

* Allow cube data type to be correctly toastable. (Teodor)

* Fix vac_update_relstats to ensure it always sends a relcache inval 
message. (Tom)


* Remove unsafe calling of WSAStartup and WSACleanup on Win32. (Magnus)

* Fix race condition in pg_database_size and pg_tablespace_size. (Alvaro)

* Allow POSIX-style timezones that don't exactly many any timezone 
database entry to be treated as having correct USA DST rules. (Tom)


* Fix longstanding bug with VACUUM FULL handling of update chains. (Tom)

* Fixed uninitialized value in pgstatindex that caused invalid values to 
be reported in some cases (Tatsuhito Kasahara)


* Insure that read-only queries are truly read-only with 
SPI_cursor_open. (Tom)


* Fixed 8.2 breakage of domains over array types. (Tom)

* Fixed parser bug (tsearch2) with UTF8 and C locales on Win32. (Teodor)

* Fix pg_wchar_table's maxmblen field of EUC_CN, EUC_TW, MULE_INTERNAL
and GB18030. (ITAGAKI Takahiro).



--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [HACKERS] Time to package 8.2.4

2007-03-26 Thread Guillaume Smet

On 3/26/07, Joshua D. Drake [EMAIL PROTECTED] wrote:

* Improve handling of psuedoconstants (Tom)


s/psuedoconstants/pseudoconstants/

And +1 to have 8.2.4 released soon. I recommend our customers to not
use 8.2 atm because of the stats problem.

--
Guillaume

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] Time to package 8.2.4

2007-03-24 Thread Grzegorz Jaskiewicz


On Mar 24, 2007, at 1:55 AM, Joshua D. Drake wrote:


Hello,

We have had several customers get bit by the 8.2.3 stats collector  
bug.
It is also starting to get reported in areas such as IRC. The  
really bad

thing about this bug is that you won't know what is wrong unless you
know where to look, PostgreSQL will just appear slow and tying up  
resources.


Can we please package 8.2.4 and get it out the door?

+1

this is a show-stopper for me, I won't move production to 8.2, unless  
that's fixed. Can't allow this to happen in production.


--
Grzegorz Jaskiewicz

C/C++ freelance for hire






---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [HACKERS] Time to package 8.2.4

2007-03-24 Thread nc-kocamana2
Am Sat, 24 Mar 2007 13:19:28 +0100 hat Grzegorz Jaskiewicz  
[EMAIL PROTECTED] geschrieben:




On Mar 24, 2007, at 1:55 AM, Joshua D. Drake wrote:


Hello,

We have had several customers get bit by the 8.2.3 stats collector bug.
It is also starting to get reported in areas such as IRC. The really bad
thing about this bug is that you won't know what is wrong unless you
know where to look, PostgreSQL will just appear slow and tying up  
resources.


Can we please package 8.2.4 and get it out the door?

+1

this is a show-stopper for me, I won't move production to 8.2, unless  
that's fixed. Can't allow this to happen in production.




+1

--

Hakan

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


[HACKERS] Time to package 8.2.4

2007-03-23 Thread Joshua D. Drake
Hello,

We have had several customers get bit by the 8.2.3 stats collector bug.
It is also starting to get reported in areas such as IRC. The really bad
thing about this bug is that you won't know what is wrong unless you
know where to look, PostgreSQL will just appear slow and tying up resources.

Can we please package 8.2.4 and get it out the door?

Joshua D. Drake

-- 

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly