looks like fid column must be of type serial

CommentFileSizeAuthor
#3 system.install_20061117_2049_patch.txt823 bytessammys
system.install_4.patch746 bytesKeymone

Comments

dries’s picture

dries commented
Component: file system » postgresql database

Care to explain why? How to reproduce?

Keymone’s picture

Keymone commented

i've installed drupal on postgresql database and just tried to upload file (after enabling upload module)

drupal produced error

Message pg_query() [function.pg-query]: Query failed: ERROR: relation `drupal_files_fid_seq` does not exist in D:\Keymone\www\drupal\includes\database.pgsql.inc on line 125.
Severity error

and

Message query: SELECT nextval('drupal_files_fid_seq') in D:\Keymone\www\drupal\includes\database.pgsql.inc on line 144.
Severity error

sammys’s picture

sammys commented
Assigned: Unassigned » sammys
Status: Needs review » Reviewed & tested by the community
StatusFileSize
new system.install_20061117_2049_patch.txt823 bytes

I concur this is a bug. The patch supplied applies, but it doesn't constrain the serial field to a positive integer. Have attached the patch with that corrected. RTBC!

dries’s picture

dries commented
Status: Reviewed & tested by the community » Fixed

Committed to CVS HEAD. Thanks.

sammys’s picture

sammys commented
Status: Fixed » Closed (duplicate)

This hasn't been resolved in HEAD actually. It appears you may have patched another branch? Another two issues have been filed about this and my latest update from HEAD doesn't have this patch applied. The other issue is at http://drupal.org/node/100143. I'm marking this as a duplicate.