From f4577bf00cf24698d63be7312f1330194f98daa5 Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Wed, 30 May 2012 23:55:27 +0200 Subject: fix for pgsql database migration --- 3rdparty/MDB2/Driver/Manager/pgsql.php | 3 +++ 1 file changed, 3 insertions(+) (limited to '3rdparty') 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)) { -- cgit v1.2.3