Hibernate version:
3.2

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="com.wazollc.alphatheory.hibernate.bo">
<class name="RoleBO"
table="`ROLE`"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version"
lazy="true"
batch-size="6"
>
<id name="id" type="java.lang.Long" column="`roleID`">
<generator class="native">
<param name="sequence">at_sequence</param>
</generator>
</id>
<version name="version" type="java.lang.Long" access="field" column="OBJ_VERSION"/>

<property name="created" column="`created`" type="timestamp"
not-null="false" />
<property name="modifiedUserFullName"
column="`modifiedUserFullName`" type="java.lang.String"
not-null="false" />
<property name="modified" column="`modified`" type="timestamp"
not-null="false" />
<property name="roleName" column="`roleName`"
type="java.lang.String" not-null="false" />
<property name="createdUserID" column="`createdUserID`"
type="java.lang.Long" not-null="false" />
<property name="modifiedUserID" column="`modifiedUserID`"
type="java.lang.Long" not-null="false" />
<property name="createdUserFullName"
column="`createdUserFullName`"
type="java.lang.String" not-null="false"
/>


</class>
</hibernate-mapping>

Name and version of the database you are using:
postgresql-8.1.9

Hi all, I'm migrating our production hibernate app from sql server to postgres. I've searched the forums a bunch and I'm unable to explain why the generated ddl doesn't follow this form, as shown from the postgres docs:

http://www.postgresql.org/docs/8.2/stat ... table.html



The hibernate mapping document I use above with hibernate tools doesn't create a ddl with 'serial' or most importantly, doesn't have nextval. It does, however, have a sequence.



Is nextval as part of the 'create table' not mandatory? Is int8 ok to use as the PK instead of 'serial'? Will hibernate call nextval with my sequence at runtime on new inserts and is that all I need? Sorry if these are more suited as postgres questions, but the hibernate generated DDL is different than what I'm reading from the postgres docs.

Thanks for any clarification!
Robert

I have an application dealing with both databases and we decided to use sequences as the base for key generation rather than serial keys. By default hibernate postgres dialect is setup for sequences. You could re-work your own version of the dialect to (possibly) make it work.

Using a sequence is a flexible and standard way to get an auto-generated column key, so hibernate is not misbehaving.

True but many databases support only serial key generaion and some support both - in this case you have a choice. Hibernate by default for postgres uses sequences (which is the best option in my personal view) so the question was 'How to make it work for serial key mode?'. Modify the dialect is the answer.