r9179: 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)

[clsql.git] / db-postgresql-socket / postgresql-socket-sql.lisp

diff --git a/db-postgresql-socket/postgresql-socket-sql.lisp b/db-postgresql-socket/postgresql-socket-sql.lisp
index 6307f05f662c7275ad363d5f170d8cea09b35edb..6a45589f1b9c2f28b61c02324c11c4d9e5cd84ce 100644 (file)
--- a/db-postgresql-socket/postgresql-socket-sql.lisp
+++ b/db-postgresql-socket/postgresql-socket-sql.lisp
@@ -325,8 +325,7 @@ doesn't depend on UFFI."
     (format nil " AND (NOT (relowner=1))"))
    (t "")))
 
-(defmethod database-list-objects-of-type ((database postgresql-socket-database)
-                                          type owner)
+(defun database-list-objects-of-type (database type owner)
   (mapcar #'car
          (database-query
           (format nil
@@ -504,5 +503,17 @@ doesn't depend on UFFI."
            (sql-escape (string-downcase table)))
    database :auto))
 
+
+;; Database capabilities
+
+(defmethod db-backend-has-create/destroy-db? ((db-type (eql :postgresql-socket)))
+  nil)
+
+(defmethod db-type-has-fancy-math? ((db-type (eql :postgresql-socket)))
+  t)
+
+(defmethod db-type-default-case ((db-type (eql :postgresql)))
+  :lower)
+
 (when (clsql-base-sys:database-type-library-loaded :postgresql-socket)
   (clsql-base-sys:initialize-database-type :database-type :postgresql-socket))