Diego Pires Plentz wrote:
I'm thinking the same thing. We could let PostgreSQLDialect to do full
support to Postgre 7.x and extend it to support the new
features/functions in Postgre 8.x. Btw, to do that, one thing that we
must do is identify what functions are new/still avaiable in 8.x. That
approach is good too, because we can get different behaviors in each
version of the database.


Major releases of Postgres are labeled n.n. Thus, each of 7.3, 7.4, 8.0, 8.1 and 8.2 has its own set of supported functions.

Moreover, Postgres is extensible, so ideally Hibernate should look at providing a way of querying a database server to get a list of supported function signatures.

Not sure how you could handle user defined types automatically, though. Probably not.

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to