From ab68c61a1212bca02686d54615d34699a853bb63 Mon Sep 17 00:00:00 2001 From: CiaranG Date: Mon, 15 Sep 2008 03:02:56 -0400 Subject: PostgreSQL: Quote table name in manually formed query - fixes profile settings update darcs-hash:20080915070256-f6e2c-344d1ca1ca158b9ab5f558804ad129c1ef9d6a7a.gz --- classes/User.php | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'classes') diff --git a/classes/User.php b/classes/User.php index 96a7482ea..cef4769f3 100644 --- a/classes/User.php +++ b/classes/User.php @@ -101,7 +101,12 @@ class User extends DB_DataObject return true; } $toupdate = implode(', ', $parts); - $qry = 'UPDATE ' . $this->tableName() . ' SET ' . $toupdate . + + $table = $this->tableName(); + if(common_config('db','quote_identifiers')) { + $table = '"' . $table . '"'; + } + $qry = 'UPDATE ' . $table . ' SET ' . $toupdate . ' WHERE id = ' . $this->id; return $this->query($qry); } -- cgit v1.2.3-54-g00ecf