gnue/geas/src/objectstore postgresql.c

[Reinhard Mueller]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     Reinhard Mueller <address@hidden>       01/06/22 09:16:22

Modified files:
        geas/src/objectstore: postgresql.c 

Log message:
        Use postgres datatype varchar instead of text for geas datatype char

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/geas/src/objectstore/postgresql.c.diff?tr1=1.8&tr2=1.9&r1=text&r2=text

Patches:
Index: gnue/geas/src/objectstore/postgresql.c
diff -u gnue/geas/src/objectstore/postgresql.c:1.8 
gnue/geas/src/objectstore/postgresql.c:1.9
--- gnue/geas/src/objectstore/postgresql.c:1.8  Thu Jun 21 23:35:10 2001
+++ gnue/geas/src/objectstore/postgresql.c      Fri Jun 22 09:16:22 2001
@@ -20,7 +20,7 @@
    along with GEAS; if not, write to the Free Software Foundation, Inc.,
    59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 
-   $Id: postgresql.c,v 1.8 2001/06/22 06:35:10 reinhard Exp $
+   $Id: postgresql.c,v 1.9 2001/06/22 16:16:22 reinhard Exp $
 */
 
 #include "config.h"
@@ -661,7 +661,7 @@
         {
           char *name, *p;
 
-          if (g_strcasecmp (PQgetvalue (res, row, 1), "TEXT") == 0)
+          if (g_strcasecmp (PQgetvalue (res, row, 1), "VARCHAR") == 0)
             type = DT_char;
           else if (g_strcasecmp (PQgetvalue (res, row, 1), "INT2") == 0)
             type = DT_int16;
@@ -671,6 +671,8 @@
             type = DT_int64;
           else if (g_strcasecmp (PQgetvalue (res, row, 1), "BOOL") == 0)
             type = DT_boolean;
+          else if (g_strcasecmp (PQgetvalue (res, row, 1), "TEXT") == 0)
+            type = DT_text;
           else if (g_strcasecmp (PQgetvalue (res, row, 1), "DATE") == 0)
             type = DT_date;
           else if (g_strcasecmp (PQgetvalue (res, row, 1), "TIME") == 0)
@@ -727,7 +729,11 @@
       switch (c->datatype)
         {
         case DT_char:
-          g_string_sprintfa (buf, "TEXT");
+          g_string_sprintfa (buf, "VARCHAR");
+          if (c->format)
+            g_string_sprintfa (buf, "(%s)", c->format);
+          else
+            g_string_sprintfa (buf, "(1)");
           break;
         case DT_int16:
           g_string_sprintfa (buf, "INT2");