Re: [BUGS] BUG #5007: could not reattach to shared memory

2009-08-24 Thread Paragon Corporation
Craig, Thanks. I assume you mean this one? http://archives.postgresql.org/pgsql-hackers/2009-07/msg01419.php I'll check with them to see if its okay if we give this a try. Thanks, Regina -Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Tuesday, August

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Peter Eisentraut
On mån, 2009-08-24 at 19:56 -0400, Tom Lane wrote: > Alvaro Herrera writes: > > Personally I still think debbugs would suit us perfectly, but 1. I don't > > have time to handle it, 2. nobody else believes this, 3. the debbugs > > developers are not very interested in helping us use it. > > What i

Re: [BUGS] BUG #5007: could not reattach to shared memory

2009-08-24 Thread Magnus Hagander
On Tuesday, August 25, 2009, Craig Ringer wrote: > On Tue, 2009-08-25 at 05:44 +, Regina wrote: >> The following bug has been logged online: >> >> Bug reference:      5007 >> Logged by:          Regina >> Email address:     �...@pcorp.us >> PostgreSQL version: 8.3.6 >> Operating system:   Wind

Re: [BUGS] BUG #5007: could not reattach to shared memory

2009-08-24 Thread Craig Ringer
On Tue, 2009-08-25 at 05:44 +, Regina wrote: > The following bug has been logged online: > > Bug reference: 5007 > Logged by: Regina > Email address: l...@pcorp.us > PostgreSQL version: 8.3.6 > Operating system: Windows 2008 Server Standard > Description:could not

[BUGS] BUG #5007: could not reattach to shared memory

2009-08-24 Thread Regina
The following bug has been logged online: Bug reference: 5007 Logged by: Regina Email address: l...@pcorp.us PostgreSQL version: 8.3.6 Operating system: Windows 2008 Server Standard Description:could not reattach to shared memory Details: One of our clients is getti

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Tom Lane
Alvaro Herrera writes: > Personally I still think debbugs would suit us perfectly, but 1. I don't > have time to handle it, 2. nobody else believes this, 3. the debbugs > developers are not very interested in helping us use it. What is it that we'd need their help for? re

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Greg Stark
On Mon, Aug 24, 2009 at 11:38 PM, Peter Eisentraut wrote: > On mån, 2009-08-24 at 23:07 +0100, Greg Stark wrote: >> I think it's a conceit to think we always fix bugs immediately. > > I completely agree with that one.  The claim that we don't need a bug > tracker because most bugs get fixed immedia

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Peter Eisentraut
On mån, 2009-08-24 at 23:07 +0100, Greg Stark wrote: > I think it's a conceit to think we always fix bugs immediately. I completely agree with that one. The claim that we don't need a bug tracker because most bugs get fixed immediately is bogus because a) it's not true, and b) it doesn't help peo

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Greg Stark
On Mon, Aug 24, 2009 at 10:16 PM, Peter Eisentraut wrote: > > Well, all you'd really need is that if you close a bug, you indicate > that say via an email header > > X-PG-Bugs-Close: 12345 > > and then spice up the archives display to show that somehow.  But the > chances of getting people to use t

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Peter Eisentraut
On mån, 2009-08-24 at 20:10 +0100, Greg Stark wrote: > It's completely email based so we could just treat it as a mailing > list without having to go visit a web interface to stay up to date. We > could add CVS/whatever hooks so whenever a commit message says it > closes a bug it gets closed automa

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Tom Lane
Robert Haas writes: > ... It seems to me based on my short > tenure reading this mailing list that when someone provides a > reproducible test case of Postgres verifiably DTWT it usually attracts > plenty of attention and gets dealt with relatively quickly, usually > with a friendly "thanks for t

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Robert Haas
On Mon, Aug 24, 2009 at 3:10 PM, Greg Stark wrote: > On Mon, Aug 24, 2009 at 8:03 PM, Alvaro > Herrera wrote: >> Personally I still think debbugs would suit us perfectly, but 1. I don't >> have time to handle it, 2. nobody else believes this, 3. the debbugs >> developers are not very interested in

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Greg Stark
On Mon, Aug 24, 2009 at 8:03 PM, Alvaro Herrera wrote: > Personally I still think debbugs would suit us perfectly, but 1. I don't > have time to handle it, 2. nobody else believes this, 3. the debbugs > developers are not very interested in helping us use it. I've been shouting about debbugs forev

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Alvaro Herrera
Robert Haas escribió: > On Mon, Aug 24, 2009 at 8:24 AM, Brian > Ceccarelli wrote: > > Yes.   I understand.   It has all to do with Unicode collating sequence.  I > > need to somehow remove this bug from the list, since it is not a bug. > > Heh. As far as I understand, there is no list... one th

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Robert Haas
On Mon, Aug 24, 2009 at 8:24 AM, Brian Ceccarelli wrote: > Yes.   I understand.   It has all to do with Unicode collating sequence.  I > need to somehow remove this bug from the list, since it is not a bug. Heh. As far as I understand, there is no list... one thing that I have been worrying abou

Re: [BUGS] 8.4.0 data loss / HOT-related bug

2009-08-24 Thread Tom Lane
Andrew Gierth writes: > "Greg" == Greg Stark writes: > Greg> Either of two things are true. > Greg> Either transaction 6179 committed, > [snip] > This is all missing the point. The row should have been killed by > transaction 4971, NOT 6179. By the time transaction 6179 tried to > do anything

Re: [BUGS] BUG #5006: Backend crashed after select with subselect in where cluase

2009-08-24 Thread Tom Lane
"Miroslav Trisc" writes: > My select : select * from wms_shp_delivery where id in ( > select shp_delivery_id from wms_shp_bins > where edi_id='5452' > ) > caused that Postgre server completely crash. We can't really do anything about this without a reproducible test case, whic

[BUGS] BUG #5006: Backend crashed after select with subselect in where cluase

2009-08-24 Thread Miroslav Trisc
The following bug has been logged online: Bug reference: 5006 Logged by: Miroslav Trisc Email address: miro.tr...@swissonline.ch PostgreSQL version: 8.4.0 Operating system: Windows Server 2003 R2 service pack 2 Description:Backend crashed after select with subselect i

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Brian Ceccarelli
Yes. I understand. It has all to do with Unicode collating sequence. I need to somehow remove this bug from the list, since it is not a bug. -Original Message- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Peter Eisentraut Sent: Monday, Au

Re: [BUGS] BUG #5004: pg_freespacemap make a SegFault

2009-08-24 Thread Sébastien Lardière
On 22/08/2009 19:52, hubert depesz lubaczewski wrote: On Fri, Aug 21, 2009 at 04:26:11PM +, Sebastien Lardiere wrote: The following bug has been logged online: Bug reference: 5004 Logged by: Sebastien Lardiere Email address: slardi...@hi-media.com PostgreSQL version:

Re: [BUGS] BUG #5004: pg_freespacemap make a SegFault

2009-08-24 Thread Sébastien Lardière
On 21/08/2009 18:51, Tom Lane wrote: "Sebastien Lardiere" writes: Description:pg_freespacemap make a SegFault There's a post-8.3.7 fix that might cure this: http://archives.postgresql.org/pgsql-committers/2009-04/msg00108.php regards, tom lane

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Peter Eisentraut
On tor, 2009-08-20 at 20:24 +, Brian Ceccarelli wrote: > since the < and > comparison operators seem to be case insensitive: > > select 'a' < 'Z';-- true > select 'a' < 'z';-- true > select 'A' < 'Z';-- true > select 'A' < 'z';-- true > > select 'z' < 'A';-- false > select