|
From: SourceForge.net <no...@so...> - 2008-08-16 18:07:54
|
Bugs item #2054924, was opened at 2008-08-16 17:11 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2054924&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mark Robinson (zl2tod) Assigned to: Nobody/Anonymous (nobody) Summary: syntax error at or near "COLUMN" at character 18 Initial Comment: The latest svn (r447) postfixadmin fails to install using pgsql. ... Updating database: old version: 438; target version: 439 updating to version 439 (PgSQL)... DEBUG INFORMATION: Invalid query: ERROR: syntax error at or near "COLUMN" at character 18 Here's a naive guess at the fix: --- upgrade-org.php 2008-08-10 11:08:27.000000000 +1200 +++ upgrade.php 2008-08-17 03:34:44.000000000 +1200 @@ -929,6 +929,7 @@ "); } function upgrade_439_pgsql() { + $table_fetchmail = table_by_key('fetchmail'); db_query_parsed(" ALTER TABLE $table_fetchmail ADD COLUMN ssl BOOLEAN NOT NULL DEFAULT false; "); ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-08-16 18:08 Message: Logged In: YES user_id=1761957 Originator: NO Patch applied to trunk; thank you! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2054924&group_id=191583 |
