Changes regarding standard_conforming_strings in postgres

[clsql.git] / sql / generic-postgresql.lisp

diff --git a/sql/generic-postgresql.lisp b/sql/generic-postgresql.lisp
index 13d4f7714d1445c10be31cdf5b267b9310f73de3..9971e4ac066824b836a140b79ef3b2801f815780 100644 (file)
--- a/sql/generic-postgresql.lisp
+++ b/sql/generic-postgresql.lisp
@@ -25,8 +25,10 @@
   "Special database types for POSTGRESQL backends"
   (declare (ignore database db-type))
   (case type
-    (wall-time ;; TODO: why is this WITHOUT...
-     "TIMESTAMP WITHOUT TIME ZONE")
+    ;; his used to be without because we didnt track timezones well
+    ;; Now we do, so it should include them
+    (wall-time
+     "TIMESTAMP WITH TIME ZONE")
     (string
      ;; TODO: the default to CHAR here seems specious as the PG docs claim
      ;; that char is slower than varchar
@@ -427,3 +429,6 @@
 
 (defmethod db-type-has-auto-increment? ((db-type (eql :postgresql)))
   t)
+
+(defmethod clsql-sys::database-escape-backslashes ((database generic-postgresql-database))
+  t)