[geeklog-cvs] geeklog: Fixed Postgres requests

[geeklog-cvs at lists.geeklog.net]

changeset 7680:7f999eeb2311
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/7f999eeb2311
user: Dirk Haun <dirk at haun-online.de>
date: Sat Jan 30 15:36:55 2010 +0100
description:
Fixed Postgres requests

diffstat:

 public_html/admin/plugins.php |  4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diffs (21 lines):

diff -r 0e7fbdc53880 -r 7f999eeb2311 public_html/admin/plugins.php
--- a/public_html/admin/plugins.php	Sat Jan 30 15:36:09 2010 +0100
+++ b/public_html/admin/plugins.php	Sat Jan 30 15:36:55 2010 +0100
@@ -942,7 +942,7 @@
             $grp_desc = addslashes($desc);
             $sql=array();
 
-            $sql['pgsql']="INSERT INTO {$_TABLES['groups']} (grp_id,grp_name, grp_descr) VALUES ((SELECT NEXTVAL('groups_grp_id_seq')),'$grp_name', '$grp_desc')";
+            $sql['pgsql']="INSERT INTO {$_TABLES['groups']} (grp_id,grp_name, grp_descr) VALUES ((SELECT NEXTVAL('{$_TABLES['groups']}_grp_id_seq')),'$grp_name', '$grp_desc')";
             $sql['mysql']="INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr) VALUES ('$grp_name', '$grp_desc')";
             $sql['mssql']="INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr) VALUES ('$grp_name', '$grp_desc')";
            
@@ -1014,7 +1014,7 @@
             $sql=array();
             
              $sql['pgsql']="INSERT INTO {$_TABLES['features']} (ft_id,ft_name, ft_descr)
-                     VALUES ((SELECT nextval('ft_id_seq'))'$ft_name', '$ft_desc')"; 
+                     VALUES ((SELECT nextval('{$_TABLES['features']}_ft_id_seq')),'$ft_name', '$ft_desc')"; 
                        
              $sql['mysql']="INSERT INTO {$_TABLES['features']} (ft_name, ft_descr)
                     VALUES ('$ft_name', '$ft_desc')";