Changes to more broadly support auto-increment. new odbc-postgresql-database type

[clsql.git] / sql / expressions.lisp

diff --git a/sql/expressions.lisp b/sql/expressions.lisp
index 10bdb5ec0b2a0dd23e7d85032da5f180e1b45315..4c57bc3e86f71ae6f97a174587bb93b546a034fb 100644 (file)
--- a/sql/expressions.lisp
+++ b/sql/expressions.lisp
@@ -1108,7 +1108,9 @@ uninclusive, and the args from that keyword to the end."
      (ecase (database-underlying-type database)
        (:mssql "IDENTITY (1,1)")
        ((:sqlite :sqlite3) "PRIMARY KEY AUTOINCREMENT")
-       (:mysql "AUTO_INCREMENT")))
+       (:mysql "AUTO_INCREMENT")
+       ;; this is modeled as a datatype instead of a constraint
+       (:postgresql "")))
     ;; everything else just get the name
     (T (string-upcase (symbol-name constraint)))))