ownCloud 4.5.2 does not work with PostgreSQL 9.2

[viq]

OwnCloud 4.5.2 does not work with PostgreSQL, at least the 9.2 branch. It is a regression from 4.5.1 where it worked. Upon installation it displays properly, but as soon as you create a directory or file you will get a 500 upon refreshing the page. I just reproduced this on CentOS and OpenBSD.

Error looks like:
2012/11/20 08:06:29 [error] 18252#0: *2563 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42703]: Undefined column: 7 ERROR: column "/Shared" does not exist
LINE 1: DELETE FROM "oc_properties" WHERE "propertypath" = "/Shared"
^' in /owncloud/lib/db.php:738Stack trace:#0 /owncloud/lib/db.php(738): PDOStatement->execute()
#1 /owncloud/lib/connector/sabre/node.php(283): PDOStatementWrapper->execute(Array)
#2 /owncloud/lib/filesystem.php(569): OC_Connector_Sabre_Node::removeETagPropertyForPath('/test')
#3 [internal function]: OC_Filesystem::removeETagHook(Array)
#4 /owncloud/lib/hook.php(62): call_user_func(Array, Array)
#5 /owncloud/lib/filecache/update.php(91): OC_Hook::emit('OC_Filesystem', 'post_write', Array)
#6 /owncloud/lib/filecache.php(258): OC_FileCache_Update::updateFolder('', false)
#7 /owncloud/lib/files.php(90): OC_FileCache::getFolderContent('', false, '')
#8 /owncloud/apps/files/index.php(47): OC_Files::getDirectoryContent('')
#9 /own" while reading response header from upstream, client: 11.22.33.44, server: owncloud.example.com, request: "GET /?app=files HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "owncloud.example.com", referrer: "https://owncloud.example.com/?app=files"

[DeepDiver1975]

this is a known issue which will be fixed with 4.5.3
Meanwhile you can manually apply this patch if you like:
8f501a9

[viq]

I did, and it works, thank you.

[DeepDiver1975]

You are welcome!