[BUGS] BUG #6124: overlaps

2011-07-19 Thread Ludek Bouska
The following bug has been logged online: Bug reference: 6124 Logged by: Ludek Bouska Email address: lu...@bouska.info PostgreSQL version: 8.3.7 Operating system: FreeBSD 7.2-RELEASE-p3 Description:overlaps Details: script select ('20110720'::date,'20110721'::date)

Re: [BUGS] BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Kevin Grittner
Tom Lane wrote: > "Kevin Grittner" writes: >> Tom Lane wrote: >>> The update causes the already-selected target row version of the >>> DELETE to be obsoleted, so heap_delete finds it has nothing to >>> do. I'm disinclined to mess with that logic. > >> It's pretty astonishing behavior for appli

Re: [BUGS] BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Tom Lane
"Kevin Grittner" writes: > Tom Lane wrote: >> The update causes the already-selected target row version of the >> DELETE to be obsoleted, so heap_delete finds it has nothing to do. >> I'm disinclined to mess with that logic. > It's pretty astonishing behavior for application programmers. It's

Re: [BUGS] BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Kevin Grittner
Tom Lane wrote: > "Kevin Grittner" writes: >> [ circular trigger relationships ] > >> I expect the DELETE from a to delete related b record(s) and then >> succeed. Instead the UPDATE in b_del_trig causes delete of a to >> silently fail. > > The update causes the already-selected target row ve

Re: [BUGS] BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Tom Lane
"Kevin Grittner" writes: > [ circular trigger relationships ] > I expect the DELETE from a to delete related b record(s) and then succeed. > Instead the UPDATE in b_del_trig causes delete of a to silently fail. The update causes the already-selected target row version of the DELETE to be obsol

[BUGS] BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Kevin Grittner
The following bug has been logged online: Bug reference: 6123 Logged by: Kevin Grittner Email address: kevin.gritt...@wicourts.gov PostgreSQL version: HEAD and 9.0.4 Operating system: Linux (probably doesn't matter) Description:DELETE fails if before trigger causes an

Re: [BUGS] BUG #6122: Installation fails: "database cluster initialisation failed"

2011-07-19 Thread Dave Page
On Tue, Jul 19, 2011 at 9:38 AM, Mike Holywell wrote: > > The following bug has been logged online: > > Bug reference:      6122 > Logged by:          Mike Holywell > Email address:      m...@segment8.co.uk > PostgreSQL version: 9.0.4 > Operating system:   Mac OSX 10.7 (Lion) > Description:      

[BUGS] BUG #6122: Installation fails: "database cluster initialisation failed"

2011-07-19 Thread Mike Holywell
The following bug has been logged online: Bug reference: 6122 Logged by: Mike Holywell Email address: m...@segment8.co.uk PostgreSQL version: 9.0.4 Operating system: Mac OSX 10.7 (Lion) Description:Installation fails: "database cluster initialisation failed" Details:

Re: [BUGS] BUG #6120: Problem running post-install step in Mac OS X Lion (GM)

2011-07-19 Thread Dave Page
On Mon, Jul 18, 2011 at 8:40 PM, Paula Andrea Carvajal Díaz wrote: > I am testing Mac OS X Lion (Gold Master). > Log file attached. Thanks. I think it's pretty safe to say I'm not going to be able to do much with this until I get my hands on a copy of Lion I'm afraid. The log shows some unexpecte