If the auto-increment feature is enabled for Postgresql tables, the tables will not be created with the SERIAL attribute.

A patch to fix this (against 4.0.2, 4.0.3) without invoking post-creation commands is available at:

http://www.freebsd.org/cgi/cvsweb.cgi/~checkout~/ports/java/jboss4/files/patch-serial-autoinc?rev=1.2&content-type=text/plain

Basically, the patch breaks down the <auto-increment-template> from 1 substitution to 3 substitutions. This allows the field creation for serial fields in Postgresql (and Informix) to be specified in detail. The patch includes corrections for databases to use the extended format.