Task #4902 (closed)
Opened 8 years ago
Closed 8 years ago
DB: Disallow PG 8.1 starting with 4.3
| Reported by: | jamoore | Owned by: | jamoore |
|---|---|---|---|
| Priority: | minor | Milestone: | OMERO-Beta4.3 |
| Component: | Deployment | Version: | n.a. |
| Keywords: | n.a. | Cc: | |
| Resources: | n.a. | Referenced By: | n.a. |
| References: | n.a. | Remaining Time: | 0.0d |
| Sprint: | 2011-04-21 (10) |
Description
Now that centos has upgraded to PG 8.2+, 8.1 can be disallowed.
Change History (3)
comment:1 Changed 8 years ago by jmoore
- Owner set to jmoore
- Remaining Time set to 0.25
- Sprint set to 2011-04-21 (10)
- Status changed from new to accepted
comment:2 Changed 8 years ago by jmoore
comment:3 Changed 8 years ago by jmoore <josh@…>
- Remaining Time changed from 0.25 to 0
- Resolution set to fixed
- Status changed from accepted to closed
(In [73b803d7baccf2280bb3e363604f66b9c66b83d0/ome.git] on branch develop) Disallowing PostgreSQL versions without pg_advisory_lock (Fix #4902)
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
The reason for disallowing 8.1 and older is that they miss a function (pg_advisory_lock) which prevents PK weirdness while working with Hibernate. If this function is missing, then we assume the version is too older and it is refused. No explicit check is performed for the version number.