Drupal user and node modules attempt to insert a blank string ('') in when the input is not specified for an integer column. MySQL allows this but not PostgreSQL. This results in a DB error.

This problem was found in node.module and user.module.

Some discussion of this issue exists in http://drupal.org/node/27870

CommentFileSizeAuthor
#1 pg_query.patch.txt2.16 KBNimish P

Comments

Nimish P’s picture

Nimish P commented
StatusFileSize
new pg_query.patch.txt2.16 KB

A patch that includes fix for the Drupal core modules - user.module and node.module.

Works for Drupal 4.6.6.

Nimish P’s picture

Nimish P commented
Status: Active » Needs review
markus_petrux’s picture

markus_petrux commented
Status: Needs review » Needs work

I believe it would be best to use %d for integers, rather than '%s'

magico’s picture

magico commented

Would this be a much wider problem related to postgresql support?

magico’s picture

magico commented
Version: 4.6.6 » 4.6.9
Status: Needs work » Closed (won't fix)

Closing due the the low interest in this.