:auto-increment support for primary keys MySQL only

Holger Schauer <[email protected]> Wed, 23 Feb 2011 10:00:21 +0100
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
Hey there,

it looks as if the support for auto-increment in CL-SQL is currently a
MySQL-ism. I.e., the code in update-records-from-instance has a
hard-coded "SELECT LAST_INSERT_ID()" in it, whereas for Postgres
(which is what I'm using) needs a CURRVAL('serial_variable') (see
https://secure.wikimedia.org/wikibooks/en/wiki/Converting_MySQL_to_PostgreSQL#Functions).

So the select should probably move to a backend specific method. I'll
see if I can come up with a patch in the next days.

Holger