Task #7813 (closed)
Doc: Drop PostgreSQL 8.3 support
Reported by: | jamoore | Owned by: | jamoore |
---|---|---|---|
Priority: | blocker | Milestone: | OMERO-4.4 |
Component: | Documentation | Version: | n.a. |
Keywords: | n.a. | Cc: | rleigh, bpindelski |
Resources: | n.a. | Referenced By: | n.a. |
References: | n.a. | Remaining Time: | 0.0d |
Sprint: | n.a. |
Description
As a temporary fix for #6224, the find_next_pixels queries added SQL2003 window functions:
select ..., row_number() over (partition by experimenter) as row from ...
These are not supported on PG 8.3.
Replacing them will take a significant amount of time and possibly include stored procedures with temporary tables.
Change History (12)
comment:1 Changed 12 years ago by jmoore
comment:2 Changed 12 years ago by jmoore
- Sprint changed from 2012-01-31 (7) to 2012-02-14 (8)
Moved from sprint 2012-01-31 (7)
comment:3 Changed 12 years ago by jburel
- Sprint changed from 2012-02-14 (8) to 2012-02-28 (9)
Moved from sprint 2012-02-14 (8)
comment:4 Changed 12 years ago by jburel
- Sprint changed from 2012-02-28 (9) to 2012-03-13 (10)
Moved from sprint 2012-02-28 (9)
comment:5 Changed 12 years ago by jburel
- Sprint changed from 2012-03-13 (10) to 2012-03-27 (11)
Moved from sprint 2012-03-13 (10)
comment:6 Changed 12 years ago by jburel
- Sprint changed from 2012-03-27 (11) to 2012-04-10 (12)
Moved from sprint 2012-03-27 (11)
comment:8 Changed 12 years ago by jmoore
- Cc omero-team@… added; cblackburn cxallan removed
- Priority changed from minor to blocker
- Remaining Time changed from 1.5 to 0.25
- Summary changed from Bug: Repair 8.3 support in SqlAction to Doc: Drop PostgreSQL 8.3 support
comment:9 Changed 12 years ago by jmoore
- Component changed from Services to Documentation
comment:10 Changed 12 years ago by jmoore
- Cc rleigh bpindelski added; omero-team@… removed
Roger: could you tackle this as a part of a overall PG review? (If so, do you want to setup a particular story / section on ReleaseProcess?)
comment:11 Changed 12 years ago by rleigh
- Remaining Time changed from 0.25 to 0
- Resolution set to fixed
- Status changed from new to closed
Documentation for 4.4 in plone and trac updated for PostgreSQL 8.4 as the minimum required version.
comment:12 Changed 12 years ago by rleigh
Updated files:
- https://www.openmicroscopy.org/site/support/copy_of_omero4/server/postgresql
- https://www.openmicroscopy.org/site/support/copy_of_omero4/server/installation
- https://www.openmicroscopy.org/site/support/copy_of_omero4/server/install-windows
- https://www.openmicroscopy.org/site/support/copy_of_omero4/known-limitations
- http://trac.openmicroscopy.org.uk/ome/wiki/OmeroContributing?version=23
- http://trac.openmicroscopy.org.uk/ome/wiki/OmeroHome?version=12
See http://www.postgresonline.com/journal/archives/79-Simulating-Row-Number-in-PostgreSQL-Pre-8.4.html