Re: [BUGS] download PostgreSQL 8.0.2

2008-12-09 Thread Guillaume Smet
On Tue, Dec 9, 2008 at 11:11 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Alexander Gallardo Torres" <[EMAIL PROTECTED]> writes: >> I need download PostgreSQL 8.0.2 but this link has problem. > > Surely you want something newer than that --- 8.0.2 was obsoleted over > three years ago. Try 8.0.15, wh

Re: [BUGS] download PostgreSQL 8.0.2

2008-12-09 Thread Tom Lane
"Alexander Gallardo Torres" <[EMAIL PROTECTED]> writes: > I need download PostgreSQL 8.0.2 but this link has problem. Surely you want something newer than that --- 8.0.2 was obsoleted over three years ago. Try 8.0.15, which I believe is the last 8.0.x release we made for Windows. (Actually, you

[BUGS] download PostgreSQL 8.0.2

2008-12-09 Thread Alexander Gallardo Torres
I need download PostgreSQL 8.0.2 but this link has problem. http://www.postgresql.org/ftp/binary/v8.0.2/win32/ Ing. Alexander Gallardo Torres Jefe DivisiĆ²n de Sistemas Tel: (57) (5) 6600671 - 6641515 Ext 109. F

Re: [postgis-devel] RE: [BUGS] BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently

2008-12-09 Thread Paul Ramsey
Yes, that patch removes the bug. P. On Sun, Dec 7, 2008 at 11:51 PM, Obe, Regina <[EMAIL PROTECTED]> wrote: > "Regina Obe" <[EMAIL PROTECTED]> writes: >> Description:Clustering on GIST INDEX clobbers records in table >> intermittently > >> This doesn't always happen to me but does intermi

Re: [BUGS] BUG #4574: LIKE fails on non-varying character with no wildcards

2008-12-09 Thread Tom Lane
"Nat!" <[EMAIL PROTECTED]> writes: > create temporary table foo ( nummer character(12) ); > insert into foo ( nummer) values( '1848' ) ; > select count(*) from foo where nummer = '1848' ; > -- returns 1 > select count(*) from foo where nummer like '1848' ; > -- returns 0 The trailing spaces are

[BUGS] BUG #4574: LIKE fails on non-varying character with no wildcards

2008-12-09 Thread Nat!
The following bug has been logged online: Bug reference: 4574 Logged by: Nat! Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.5 Operating system: Mac OS X 10.4 Description:LIKE fails on non-varying character with no wildcards Details: The documentation clai

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-09 Thread Tom Lane
Marc Schablewski <[EMAIL PROTECTED]> writes: > cache_value is set to one for all sequences. As far as I can tell, they > were all created by a plain CREATE SEQUENCE seq_name and no other > settings changed. And as we found out later this "loss of information" > hit some indexes as well. > We took

Re: [BUGS] BUG #4573: download problem

2008-12-09 Thread Dave Page
On Tue, Dec 9, 2008 at 12:47 PM, Pavan Deolasee <[EMAIL PROTECTED]> wrote: > > > On Tue, Dec 9, 2008 at 4:54 PM, Adam Pewny <[EMAIL PROTECTED]> wrote: >> >> >> I have an application, which runs only with this specific version of >> PostgreSQL (8.2.4-1). I've tried to download aa ZIP file with insta

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-09 Thread Marc Schablewski
Tom Lane wrote: > "Marc Schablewski" <[EMAIL PROTECTED]> writes: > >> A job tried to insert some records into a few tables and complained about a >> PK violation. PK are of type bigint. The column is populated by a sequence >> and a "default nextval()" on the PK column. We found that the sequenc

Re: [BUGS] BUG #4573: download problem

2008-12-09 Thread Pavan Deolasee
On Tue, Dec 9, 2008 at 4:54 PM, Adam Pewny <[EMAIL PROTECTED]> wrote: > > > I have an application, which runs only with this specific version of > PostgreSQL (8.2.4-1). I've tried to download aa ZIP file with installer, > but > it's not available on any mirror weather http or ftp. Is any way to ge

[BUGS] BUG #4573: download problem

2008-12-09 Thread Adam Pewny
The following bug has been logged online: Bug reference: 4573 Logged by: Adam Pewny Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4-1 Operating system: Windows Vista Description:download problem Details: I have an application, which runs only with this sp

Re: [BUGS] BUG #4572: Incorrect error message when using wrong password with hostssl

2008-12-09 Thread Magnus Hagander
Tommy Gildseth wrote: > The following bug has been logged online: > > Bug reference: 4572 > Logged by: Tommy Gildseth > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.x,8.2.x > Operating system: Linux > Description:Incorrect error message when using wrong p

[BUGS] BUG #4572: Incorrect error message when using wrong password with hostssl

2008-12-09 Thread Tommy Gildseth
The following bug has been logged online: Bug reference: 4572 Logged by: Tommy Gildseth Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.x,8.2.x Operating system: Linux Description:Incorrect error message when using wrong password with hostssl Details: When