Hi!
I have a little problem with hibernate(2.0.3) and postgres (7.2)
when i use net.sf.hibernate.tool.hbm2ddl.SchemaExport to generate my database
i've used a lot of different drivers JDBC and the result is the same.
It perfectly run with hsqldb (good for test ;-) so i don't think it's a problem of hbm file.
here are some example of the errors :
v.g. :
alter table DOCUMENT drop constraint FK6202C11BED92EF77
Unsuccessful: ERROR: parser: parse error at or near ""

alter table GROUPEPUBLICATION drop constraint FK35123086F73AEE0F
Unsuccessful: ERROR: parser: parse error at or near ""

alter table GROUPEPUBLICATION drop constraint FK35123086B0EF4182
Unsuccessful: ERROR: parser: parse error at or near ""

drop table USER
Unsuccessful: ERROR: parser: parse error at or near "USER"
etc...

my properties are :
hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class org.postgresql.Driver
hibernate.connection.url jdbc:postgresql://lxn15:8000/gedeon

If somebody have an idea...
thanks for help
Pierre-Marin[/i]

Did you generate the script and apply it manually or let SchemaExport apply it (no script file)?

I let SchemaExport apply it : i just give it as argument the name of path of the hbm file and it call the postgres database and connect to it and send it the script but after come the errors...

Do not name a table USER in postgres...

eheh, not only in postgres ;-)