[BUGS] BUG #5131: The pgsql will lost

2009-10-21 Thread aihongwei
The following bug has been logged online: Bug reference: 5131 Logged by: aihongwei Email address: ufo008...@163.com PostgreSQL version: 8.0.0 Operating system: linux x86_64 Description:The pgsql will lost Details: In x86_64 platform, I input command "ulimit -s 2048"

Re: [BUGS] BUG #5126: convert_to preventing index scan

2009-10-21 Thread Peter Eisentraut
On Mon, 2009-10-19 at 11:05 +, Roman Kapusta wrote: > I have table with bytea column, which is indexed (1) > I want to use index during pattern matching (eg. dir like > someDirectoryName > || '/%'), but concatenation of two strings cause error (2) > So I have to use function convert_to (convert

[BUGS] BUG #5130: Failed to run initdb:1

2009-10-21 Thread
The following bug has been logged online: Bug reference: 5130 Logged by: Email address: flamindrag...@gmail.com PostgreSQL version: any Operating system: Win XP Pro SP2 Description:Failed to run initdb:1 Details: here's the log of the bug The files belonging to th

Re: [BUGS] BUG #5129: LIMIT not correct.

2009-10-21 Thread Tom Lane
Andres Freund writes: > On Wednesday 21 October 2009 05:37:36 Thach Anh Tran wrote: >> the LIMIT clause is not reply correct number of rows and rows returns. > Read the second caution block in the relevant section of the manual: > http://www.postgresql.org/docs/current/interactive/sql-select.html

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-21 Thread Andrew Dunstan
Magnus Hagander wrote: From a quick look, it looks fine to me. I don't have time to do a complete check right now, but I'll do that as soon as I can and then commit it - unless people feel it's more urgent than maybe a week worst case, in which case someone else has to pick it up :-) I'd

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-21 Thread Magnus Hagander
On Wed, Oct 21, 2009 at 15:07, Tom Lane wrote: > Dave Page writes: >> This function call is adding the new access control entry to the DACL, >> and in Jesse's modified version it's specifying that the ACE should be >> inheritable. > > Hah, so now we have a theory. > >> The other refactoring is st

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-21 Thread Tom Lane
Dave Page writes: > This function call is adding the new access control entry to the DACL, > and in Jesse's modified version it's specifying that the ACE should be > inheritable. Hah, so now we have a theory. > The other refactoring is still important however - without it, I still > see the erro

Re: [BUGS] BUG #5127: AbstractJdbc2Connection#doRollback should throws Exception if connection is closed

2009-10-21 Thread taktos
> Is it possible that you have autoCommit set to true? No, it is impossible as you know. Sample code I wrote is just a sample. Actually I use a DI container (Seasar, it is a popular DI container in Japan), and Seasar provides DBCP implementation. > This makes me concerned that fixing the bug

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-21 Thread Dave Page
On Wed, Oct 21, 2009 at 8:45 AM, Dave Page wrote: > On Tue, Oct 20, 2009 at 5:45 PM, Tom Lane wrote: > >> Seems like it would be worth the trouble to identify exactly what the >> critical difference is. > > Given Jesse's description of the systems he's seen this on, I suspect > we'll be very luck

Re: [BUGS] BUG #5129: LIMIT not correct.

2009-10-21 Thread Andres Freund
On Wednesday 21 October 2009 05:37:36 Thach Anh Tran wrote: > The following bug has been logged online: > > Bug reference: 5129 > Logged by: Thach Anh Tran > Email address: myqua...@gmail.com > PostgreSQL version: 8.3.8 > Operating system: Linux > Description:LIMIT not

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-21 Thread Dave Page
On Tue, Oct 20, 2009 at 5:45 PM, Tom Lane wrote: > Seems like it would be worth the trouble to identify exactly what the > critical difference is. Given Jesse's description of the systems he's seen this on, I suspect we'll be very lucky if we pin that down, unless it is something as simple as wi