auto-increment & PostgreSQL

[mike80439]

I'd like to be able to call the postgres function nextval from EJBQL. I could then include the value in the call to create. Is there a way to do this?

I can set my auto-increment field using a db trigger, but the EJB never sees the value.

Also, does anyone have an example of the postgresql-fetch-seq command in standardjbosscmp-jdbc.xml?

Thanks a bunch.

[alanbram]

Please see my reply to a related question:

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=