Postgres problem - filemanager

There is one more thing that needs to be 'tweaked' before the filemanager will work with Postgres. In the filemanger_add_file function, you need to change the insert statement:

INSERT INTO {file} (fid, area, directory, filename, mimetype, size, active, working, private) VALUES (%d,'%s',%d,'%s','%s',%d,'%s','%s','%s')

to this

INSERT INTO {file} (fid, area, directory, filename, mimetype, size, active, working, private) VALUES (%d,'%s',%d,'%s','%s',%d,%d,'%s',%d)

And in the function filemanager_promote_working:

UPDATE {file} SET working='%s', active='%s', size=%d WHERE fid=%d

to this

UPDATE {file} SET working='%s', active=%d, size=%d WHERE fid=%d

Postgres handles boolean values differently than MySQL, so it is necessary to cast the 'active' and 'private' values to integers instead of strings.

Whoops. Kings 'X'. I completely misinterpreted what was going on with those boolean values. Sure, the above 'fix' worked for me with publicly accessible files, but when I switched over to private files, all hell broke loose. My apologies.

I'm attaching a patch correcting the immediately visible problems with AS being missing.

There remains a problem with private files not being copied properly.

fixed the as problem... I dont' have postgres anywhere so I can't test the current module with it.