From 54dd42c31897ae3649a0bdecaa8d65be3cf65a4e Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Mon, 12 May 2008 09:23:12 -0400
Subject: [PATCH] - fixed problem with postgresql sequences (after MDB2 drivers update)

---
 program/include/main.inc |   17 +++++++++++++----
 1 files changed, 13 insertions(+), 4 deletions(-)

diff --git a/program/include/main.inc b/program/include/main.inc
index b436f82..5960791 100644
--- a/program/include/main.inc
+++ b/program/include/main.inc
@@ -69,14 +69,23 @@
  */
 function get_sequence_name($sequence)
   {
-  global $CONFIG;
-
   // return table name if configured
   $config_key = 'db_sequence_'.$sequence;
+  $opt = rcmail::get_instance()->config->get($config_key);
 
-  if (strlen($CONFIG[$config_key]))
-    return $CONFIG[$config_key];
+  if (!empty($opt))
+    {
+    $db = &rcmail::get_instance()->db;
 
+    if($db->db_provider=='pgsql') // just for sure
+      {
+      $db->db_handle->setOption('disable_smart_seqname', true);
+      $db->db_handle->setOption('seqname_format', '%s');
+      }	      
+  
+    return $CONFIG[$opt];
+    }
+    
   return $sequence;
   }
 

--
Gitblit v1.9.1