update.php from D5 to head doesn't work on pg7.4 - because you can't add constraints or default in the same statement as column add. Sure, it can be patched (and i've got one i'll submit) but how does the project fee about dropping old 7.4 and requiring pg8.0? If not for D6 then at least D7. It's an easy upgrade path, and 8 is in most distros (i dunno about redhat)
It is difficult to upgrade to PostgreSQL on RHEL4. Brenda Wallace wrote:
update.php from D5 to head doesn't work on pg7.4 - because you can't add constraints or default in the same statement as column add.
Sure, it can be patched (and i've got one i'll submit) but how does the project fee about dropping old 7.4 and requiring pg8.0? If not for D6 then at least D7. It's an easy upgrade path, and 8 is in most distros (i dunno about redhat)
It is difficult to upgrade to PostgreSQL on RHEL4.
You can get RPM from PostgreSQL site. I think One rpm was not available from public FTP but quick search on their mailing list archive brought up the link. Thats how I ran earlier but I have since then moved to RHEL5 but am still using RPM from PostgreSQL site. It works fine and stable. ____________________________________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/
update.php from D5 to head doesn't work on pg7.4 - because you can't add constraints or default in the same statement as column add.
I wrote the schema SQL generator for PostgreSQL and I guess I suspected it would not work with 7.4. I developed on Windows which does not support pg 7.4 so I had no way to test with that platform. I probably should have made some noise about that. I don't know enough about the pg-using community to know whether support for 7.4 matters.
Sure, it can be patched (and i've got one i'll submit)
If you have a patch, I suggest submitting it. The conversation about what to do re: pg 7.4 can then happen in that thread. Have you tried schema.module on pg 7.4? I'm curious to know whether its database schema inspection code works... Thanks, Barry
On Sat, 2007-09-15 at 18:12 -0400, Barry Jaspan wrote:
If you have a patch, I suggest submitting it. The conversation about what to do re: pg 7.4 can then happen in that thread.
Have you tried schema.module on pg 7.4? I'm curious to know whether its database schema inspection code works...
I've got a patch, but i wanna rethink it. it takes the beauty and elegance in there and poops arrays all over it. There are other issues in the D5 -> D6 upgrade path. Who is testing upgrades against pg8.0?? I'll do pg8 tests too but i've put it at the end of my todo list for now, while resolving 7.4 problems. Which is more important to the project right now?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brenda Wallace schrieb:
On Sat, 2007-09-15 at 18:12 -0400, Barry Jaspan wrote:
If you have a patch, I suggest submitting it. The conversation about what to do re: pg 7.4 can then happen in that thread.
Have you tried schema.module on pg 7.4? I'm curious to know whether its database schema inspection code works...
I've got a patch, but i wanna rethink it. it takes the beauty and elegance in there and poops arrays all over it.
There are other issues in the D5 -> D6 upgrade path.
Who is testing upgrades against pg8.0??
I guess the number of people doing this is small. Very small. So getting some more testers would be appreciated.
I'll do pg8 tests too but i've put it at the end of my todo list for now, while resolving 7.4 problems. Which is more important to the project right now?
Ask the people who actually use pgsql. I personally don't mind to drop pgsql 7.4 support. Cheers, Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG7Hodfg6TFvELooQRAqXWAKDDTWgeOVJPN25ONyUE0KVy67M2YQCfZI2I sMQEk0m89ttbk+ZSFmpda0Q= =azsn -----END PGP SIGNATURE-----
Ask the people who actually use pgsql. I personally don't mind to drop pgsql 7.4 support.
It maybe better to post the query on drupal forums. As many users may still wont be on dev list. ____________________________________________________________________________________ Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
On Sat, 2007-09-15 at 22:55 -0700, Vivek Puri wrote:
Ask the people who actually use pgsql. I personally don't mind to drop pgsql 7.4 support.
It maybe better to post the query on drupal forums. As many users may still wont be on dev list.
Brenda,
Who is testing upgrades against pg8.0??
I developed the D5 -> D6 upgrade patch concurrently for pg 8 and mysql (in fact, I tested pg8 first). I also developed the pg8 Schema API code in database-pgsql.inc and the pg schema inspection code in schema.module. I regularly check the results of a clean install and a D5 to D6 upgrade for both databases, using the schema.module to verify database schema consistency. Of course, that is different than actually testing Drupal's full functionality. Thanks, Barry
participants (5)
-
Barry Jaspan -
Brenda Wallace -
David Strauss -
Gerhard Killesreiter -
Vivek Puri