[BUGS] BUG #4553: HOLD cursors not materializing results fully

2008-11-28 Thread Andrew Gierth
The following bug has been logged online: Bug reference: 4553 Logged by: Andrew Gierth Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3-8.4 Operating system: all Description:HOLD cursors not materializing results fully Details: (tested on 8.3.5 and HEAD as o

Re: [BUGS] BUG #4551: Implementation of the "line" type..

2008-11-28 Thread John R Pierce
Peter Eisentraut wrote: No really, the built-in geometry types are considered kind of legacy. Indeed, I was reviewing the postgres 'history' on the website the other day, and noted that stuff was put in Postgres *BEFORE* it was SQL. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresq

Re: [BUGS] BUG #4552: password

2008-11-28 Thread toruvinn
On Fri, 28 Nov 2008 19:36:31 +0100, <[EMAIL PROTECTED]> wrote: i reinstal postgre but they ask me a password but i find i can put dbpass but this not work what i had to do plz? Hmm... Ok, here it goes: if i wer u i wud try to remov ze old postgre data dir unfortunaty i haz no idea wher it res

[BUGS] query failed, not enough memory on 8.3.5

2008-11-28 Thread Grzegorz Jaskiewicz
hey folks (please CC, I'm not subscribed). I am trying to merge duplicates of two fields in a rather large table (139M rows, about 7GB of data). creating helper table, that would hold it. my feeling is, postgresql shouldn't go beyond memory bounds I am setting it in conf, never had any probl

[BUGS] BUG #4552: password

2008-11-28 Thread
The following bug has been logged online: Bug reference: 4552 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: 5432 Description:password Details: i reinstal postgre but they ask me a password but i find i can put dbpass but this

Re: [BUGS] BUG #4551: Implementation of the "line" type..

2008-11-28 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > No really, the built-in geometry types are considered kind of legacy. If you > want to deal with something more modern, you may want to look into PostGIS. Or, if you want to fix them, feel free to submit a patch. But there is no one among the curren

Re: [BUGS] BUG #4551: Implementation of the "line" type..

2008-11-28 Thread Peter Eisentraut
On Friday 28 November 2008 15:31:51 Barry Sanford wrote: > looking at PostgreSQL, I noticed that you have various geometric data types > as standard. However, I was somewhat surprised that you are attempting to > implement the 'line' type via a two point scheme. While this is okay for > line segm

[BUGS] BUG #4551: Implementation of the "line" type..

2008-11-28 Thread Barry Sanford
The following bug has been logged online: Bug reference: 4551 Logged by: Barry Sanford Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: OS X Description:Implementation of the "line" type.. Details: My company does structural analysis of arc