It's not a big issue really but the table definition for {page_title} for PostgreSQL
is set with a column type of TEXT for the 'page_title' column. It is set as a
VARCHAR(255) for MySQL. For efficiency sake and for consistency between the
tables in both databases the column in PostgreSQL should be changed to
a VARCHAR.

CommentFileSizeAuthor
#2 page_title.install.238555.patch1.44 KBjaydub

Comments

nicholasthompson’s picture

Category: support » bug
Status: Active » Postponed (maintainer needs more info)

I've never used PostgreSQL (ever) - so would appreciate a patch for this (plus help testing).

Can you also provide an update function which will alter the table in PostgreSQL to be correct.

jaydub’s picture

Assigned: Unassigned » jaydub
Status: Postponed (maintainer needs more info) » Needs review
StatusFileSize
new1.44 KB

here you go. tested it out and it worked for me at least...

jaydub’s picture

the table was missing the PRIMARY KEY for (nid) as well so I included
that change as well

nicholasthompson’s picture

cheers

nicholasthompson’s picture

Status: Needs review » Fixed

Fixed in latest DRUPAL-5--2 release - commit here:
http://drupal.org/cvs?commit=127925

Anonymous’s picture

Status: Fixed » Closed (fixed)

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