From 1f0c7fae156092fc26bd77069182a7c98ba40f47 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Sun, 1 Oct 2006 15:48:29 +0000
Subject: [PATCH] Now PG adds fields in various steps is order to fulfill 7.4
 min req

---
 .../generators/postgres7/postgres7.class.php  | 40 +++++++++++++++++++
 1 file changed, 40 insertions(+)

diff --git a/lib/xmldb/classes/generators/postgres7/postgres7.class.php b/lib/xmldb/classes/generators/postgres7/postgres7.class.php
index 7a1e3e68fb..e787f31735 100644
--- a/lib/xmldb/classes/generators/postgres7/postgres7.class.php
+++ b/lib/xmldb/classes/generators/postgres7/postgres7.class.php
@@ -155,6 +155,46 @@ class XMLDBpostgres7 extends XMLDBgenerator {
         return $results;
     }
 
+    /**
+     * Given one XMLDBTable and one XMLDBField, return the SQL statements needded to add the field to the table
+     * PostgreSQL is pretty standard but with one severe restriction under 7.4 that forces us to overload
+     * this function: Default clause is not allowed when adding fields.
+     * 
+     * This function can be safely removed once min req. for PG will be 8.0
+     */
+    function getAddFieldSQL($xmldb_table, $xmldb_field) {
+    
+        $results = array();
+
+        $tablename = $this->getTableName($xmldb_table);
+        $fieldname = $this->getEncQuoted($xmldb_field->getName());
+
+        $defaultvalue = null;
+
+    /// Prevent default clause and launch parent getAddField()
+        $this->alter_column_skip_default = true;
+        $this->alter_column_skip_notnull = true;
+        $results = parent::getAddFieldSQL($xmldb_table, $xmldb_field);
+
+    /// Add default
+        if ($defaultclause = $this->getDefaultClause($xmldb_field)) {
+            $defaultvalue = $this->getDefaultValue($xmldb_field);
+            $results[] = 'ALTER TABLE ' . $tablename . ' ALTER COLUMN ' . $fieldname . ' SET' . $defaultclause; /// Add default clause
+        }
+
+    /// Update default value (if exists) to all the records
+        if ($defaultvalue !== null) {
+            $results[] = 'UPDATE ' . $tablename . ' SET ' . $fieldname . '=' . $defaultvalue;
+        }
+
+    /// Add not null
+        if ($xmldb_field->getNotnull()) {
+            $results[] = 'ALTER TABLE ' . $tablename . ' ALTER COLUMN ' . $fieldname . ' SET NOT NULL'; /// Add not null
+        }
+
+        return $results;
+    }
+
     /**
      * Given one XMLDBTable and one XMLDBField, return the SQL statements needded to alter the field in the table
      * PostgreSQL has some severe limits:
-- 
2.39.5