I am running the stable release of Debian (woody), which comes with postgresql 7.2. The problem is, Drupal (at least the CVS release) tries to create a table called "path". This is a problem, since technically, "path" is a reserved keyword. Apparently, in versions 7.3 and up, this keyword checking is not as strict, and it "just works."

After importing the database.pgsql script, the error "ERROR: type named path already exists" shows up, and the table "path" is never created. I tried modifying the script to put the word "path" in quotes, but it still fails

I would upgrade postgresql, but that would mean upgrading to the "testing" or "unstable" versions of postgresql. While this is not a big deal in itself, it would mean having to do some serious upgrades (libc, gcc, etc), which would turn out to be messy.

Is there a workaround to this? I am sure that there are several other postgres/Debian users who would like to keep NOT have to upgrade their whole system just to get drupal working. If I need to make the modifications myself (change the tablename), could you tell me exactly where these changes need to be made?

Thanks

Comments

adrian’s picture