From d98a0a1bb9c52f18c716267682644e2d2b43659d Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Wed, 30 May 2012 23:55:27 +0200 Subject: [PATCH] fix for pgsql database migration --- 3rdparty/MDB2/Driver/Manager/pgsql.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/3rdparty/MDB2/Driver/Manager/pgsql.php b/3rdparty/MDB2/Driver/Manager/pgsql.php index a7b776cc1b7..f2c2137dc8b 100644 --- a/3rdparty/MDB2/Driver/Manager/pgsql.php +++ b/3rdparty/MDB2/Driver/Manager/pgsql.php @@ -410,6 +410,9 @@ class MDB2_Driver_Manager_pgsql extends MDB2_Driver_Manager_Common } $db->loadModule('Datatype', null, true); $type = $db->datatype->getTypeDeclaration($field['definition']); + if($type=='SERIAL PRIMARY KEY'){//not correct when altering a table, since serials arent a real type + $type='INTEGER';//use integer instead + } $query = "ALTER $field_name TYPE $type USING CAST($field_name AS $type)"; $result = $db->exec("ALTER TABLE $name $query"); if (PEAR::isError($result)) { -- 2.39.5