By Shiny on

How about drupal7 drops support for the old postgres 7.4 and require version 8.0 or later

The upgrade from 7.4 to 8.0 is an easy one, and pg8+ is in most distros.

some examples of features missing from 7.4 (that drupal 6 uses)

add constraint when added a column
add default when adding a column
adding a column of type serial.

probably more.

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Version 8.0 has been released on 17.01.2005. That should definitely be enough time to upgrade.

Based on the discussion in the development list, the question of this thread should have been:

Who needs still support for PostGreSQL 7.4 in Drupal 6?

Daniel F. Kudwien
unleashed mind

Daniel 'sun' Kudwien
makers99

vivek.puri’s picture

vivek.puri commented

postgreSQL 8 also has better performance so its a good move.

ywarnier’s picture

ywarnier commented

I've been trying to upgrade from 5.x to 6.2 and some queries (for example ALTER TABLE cache ADD COLUMN serialized smallint NOT NULL DEFAULT 0) already use a syntax that is not supported by 7.4, so obviously there's no point in even wondering, the documentation should indicate that it's already a prerequisite for 6.x I guess... (somebody around with the permissions to do that?)
The INSTALL.txt in Drupal 6.2 says:

"Drupal requires a web server, PHP 4 (4.3.5 or greater) or PHP 5
(http://www.php.net/) and either MySQL (http://www.mysql.com/) or PostgreSQL
(http://www.postgresql.org/). The Apache web server and MySQL database are
recommended; other web server and database combinations such as IIS and
PostgreSQL have been tested to a lesser extent. When using MySQL, version 4.1.1
or greater is recommended to assure you can safely transfer the database."

But that doesn't say anything about PG >= 8.0, which, somehow, is misleading...

There is apparently some code in database.pgsql.inc which is supposed to tackle that case (alter table with a "not null" param) but it doesn't seem to be applied where it should be, so the upgrade falls quite flat on its back...

--
Yannick Warnier
Project leader, Chamilo LMS
http://beeznest.wordpress.com/author/ywarnier
https://flattr.com/profile/ywarnier