Download & Extend

PostgreSQL 7.3 is _not_ supported

Project:Drupal core
Version:5.x-dev
Component:postgresql database
Category:bug report
Priority:normal
Assigned:dww
Status:closed (fixed)

Issue Summary

1) includes/database.pgsql.inc uses SHOW SERVER_VERSION to determine which postgresql version we're running, but that statement was only introduced in 7.4.
Fix: none that I know.

2) modules/system/system.install tries to define three domains with range checks (the unsigned integer types); range checks on domains were introduced in 7.4.
Fix: none that I know.

3) modules/system/system.install contains an 'ALTER SEQUENCE ... MINVALUE 2 RESTART 2' statement, which was introduced in 7.4.
Fix: use SELECT setval('...', 2). In 7.3 there is no way to set a sequence's min_value after its creation, but I don't think there are any reasons to either...

4) modules/system/system.install defines some functional indexes (indexes on functions of columns). Functional indexes support is very crude in 7.3 and does not allow functions taking other arguments than the column name, or mixing functions and simple columns as keys. 7.4 should be ok in this regard.
Fix: none that I know of.

Since I am just doing a test install of drupal none of this issues is a real showstopper to me; however I think that the minimum PostgreSQL version in the requirements page should be upgraded to 7.4.

Comments

#1

Assigned to:Anonymous» dww
Status:active» needs review

yeah, seems far better to just change the minimum required than to try to fix all of those problems.

AttachmentSizeStatusTest resultOperations
pgsql_7_4_required.patch.txt673 bytesIgnored: Check issue status.NoneNone

#2

I'm OK with the proposed patch.

#3

Status:needs review» fixed

Committed to CVS HEAD and DRUPAL-5. Thanks.

#4

Status:fixed» closed (fixed)

#5

Status:closed (fixed)» active

Just downloaded 5.7 and tried to run against PostgreSQL 7.3, and, lo and behold, this patch was apparently *not* applied. Ran into exactly this bug. Also, the system min. requirements still say PostgreSQL 7.3.

#6

Version:5.0» 5.x-dev
Status:active» reviewed & tested by the community

Indeed. It seems this was never actually committed to DRUPAL-5. It is fixed in DRUPAL-6 and HEAD, however. Re-rolled for DRUPAL-5.

AttachmentSizeStatusTest resultOperations
pgsql_7_4_required.d5.patch681 bytesIgnored: Check issue status.NoneNone

#7

Yeah, I think we should commit this to DRUPAL-5.

#8

Status:reviewed & tested by the community» fixed

Committed to 5.x.

#9

Status:fixed» closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

nobody click here