Re: [BUGS] BUG #6191: One click installer fails

2011-09-01 Thread Dave Page
On Thu, Sep 1, 2011 at 2:47 AM, Mark Lamberton wrote: > > The following bug has been logged online: > > Bug reference:      6191 > Logged by:          Mark Lamberton > Email address:      m...@penguinsystems.com.au > PostgreSQL version: 9.0.4-1 > Operating system:   Windows 7 > Description:      

Re: [BUGS] BUG #6186: out of memory while analyze

2011-09-01 Thread Valentine Gogichashvili
> > > ssl = false > shared_buffers = 900MB # min 128kB > work_mem = 100MB# min 64kB > maintenance_work_mem = 524MB# min 1MB > fsync = off # turns forced synchronization on > or off > synchronous_commit = off

[BUGS] ECPGdo fails to restore LC_NUMERIC

2011-09-01 Thread Heikki Linnakangas
ECPGdo function in ecpglib sets LC_NUMERIC locale temporarily to C, to make sure it uses the '.' as the decimal separator for any numerics it sends to the backend. However, it fails to restore it back to the original locale in some error cases. I can see two returns from the function that negle

Re: [BUGS] The translation into Bulgarian

2011-09-01 Thread Kevin Grittner
"Albert Ward" wrote: > would like to translate it to Bulgarian language, so I can share > it with the readers on my blog. This is not a bug, so it doesn't belong on this list. I will reply to the duplicate post on docs shortly. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgr

Re: [BUGS] ECPGdo fails to restore LC_NUMERIC

2011-09-01 Thread Michael Meskes
On Thu, Sep 01, 2011 at 02:27:07PM +0300, Heikki Linnakangas wrote: > ECPGdo function in ecpglib sets LC_NUMERIC locale temporarily to C, > to make sure it uses the '.' as the decimal separator for any > numerics it sends to the backend. However, it fails to restore it > back to the original locale

[BUGS] BUG #6192: Incorrect result from operator "overlaps"

2011-09-01 Thread Incorrect result from operator
The following bug has been logged online: Bug reference: 6192 Logged by: Incorrect result from operator "overlaps" Email address: wolfm...@o2.pl PostgreSQL version: 9.0.4 Operating system: Debian/Sid Description:Incorrect result from operator "overlaps" Details: SEL

Re: [BUGS] BUG #6186: out of memory while analyze

2011-09-01 Thread Lampa
Hello, /proc/sys/vm/swappiness = 60 /proc/sys/vm/overcommit_memory = 0 /proc/sys/vm/overcommit_ratio = 50 total used free sharedbuffers cached Mem: 4038 3146892 0 30 3067 -/+ buffers/cache: 49 3989 Sw

Re: [BUGS] BUG #6192: Incorrect result from operator "overlaps"

2011-09-01 Thread Vik Reykja
On Thu, Sep 1, 2011 at 10:27, Incorrect result from operator wrote: > > SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps > ('2011-08-1'::date,'2011-08-31'::date); > Returns false, should return true. > According to the documentation, it should return false. "Each time period is considere

Re: [BUGS] BUG #6192: Incorrect result from operator "overlaps"

2011-09-01 Thread Tom Lane
"Incorrect result from operator "overlaps"" writes: > SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps > ('2011-08-1'::date,'2011-08-31'::date); > Returns false, should return true. This is correct per SQL standard. The spec is written such that an interval is considered half-open, ie ['2

[BUGS] BUG #6193: The one-click installer failed to unpack

2011-09-01 Thread farta
The following bug has been logged online: Bug reference: 6193 Logged by: farta Email address: fayfa...@gmail.com PostgreSQL version: 9.0.4 Operating system: Windows 7 64 bit Description:The one-click installer failed to unpack Details: postgresql-9.0.4-1-windows_x64