[GNUnet-SVN] r8603 - GNUnet/src/applications/sqstore_postgres

[gnunet]

Author: grothoff
Date: 2009-06-25 08:48:33 -0600 (Thu, 25 Jun 2009)
New Revision: 8603

Modified:
   GNUnet/src/applications/sqstore_postgres/postgres.c
Log:
disable compression

Modified: GNUnet/src/applications/sqstore_postgres/postgres.c
===================================================================
--- GNUnet/src/applications/sqstore_postgres/postgres.c 2009-06-24 13:39:32 UTC 
(rev 8602)
+++ GNUnet/src/applications/sqstore_postgres/postgres.c 2009-06-25 14:48:33 UTC 
(rev 8603)
@@ -247,6 +247,47 @@
         }
     }
   PQclear (ret);
+#if 1
+  ret = PQexec (dbh,
+                "ALTER TABLE gn080 ALTER value SET STORAGE EXTERNAL");
+  if ((ret == NULL) || ((PQresultStatus (ret) != PGRES_COMMAND_OK) && 
+                       (0 != strcmp ("42P07",    /* duplicate table */
+                                     PQresultErrorField
+                                     (ret,
+                                      PG_DIAG_SQLSTATE)))))
+    {
+      check_result (ret, PGRES_COMMAND_OK, "ALTER TABLE", "gn080", __LINE__);
+      PQfinish (dbh);
+      dbh = NULL;
+      return GNUNET_SYSERR;
+    }
+  ret = PQexec (dbh,
+                "ALTER TABLE gn080 ALTER hash SET STORAGE PLAIN");
+  if ((ret == NULL) || ((PQresultStatus (ret) != PGRES_COMMAND_OK) && 
+                       (0 != strcmp ("42P07",    /* duplicate table */
+                                     PQresultErrorField
+                                     (ret,
+                                      PG_DIAG_SQLSTATE)))))
+    {
+      check_result (ret, PGRES_COMMAND_OK, "ALTER TABLE", "gn080", __LINE__);
+      PQfinish (dbh);
+      dbh = NULL;
+      return GNUNET_SYSERR;
+    }
+  ret = PQexec (dbh,
+                "ALTER TABLE gn080 ALTER vhash SET STORAGE PLAIN");
+  if ((ret == NULL) || ((PQresultStatus (ret) != PGRES_COMMAND_OK) && 
+                       (0 != strcmp ("42P07",    /* duplicate table */
+                                     PQresultErrorField
+                                     (ret,
+                                      PG_DIAG_SQLSTATE)))))
+    {
+      check_result (ret, PGRES_COMMAND_OK, "ALTER TABLE", "gn080", __LINE__);
+      PQfinish (dbh);
+      dbh = NULL;
+      return GNUNET_SYSERR;
+    }
+#endif
   if ((GNUNET_OK !=
        pq_prepare ("getvt",
                    "SELECT size, type, prio, anonLevel, expire, hash, value, 
oid FROM gn080 "