On Thursday 19 June 2003 11:40 am, Gerard van Enk wrote: > Peter Reitsma wrote: > > To whom it may concern, > > > > Trying to get MMBase working on Postgresql 7.3.2 I encountered the > > following error: > > What MMBase version are you using? > > > If MMBase is supposed to work fine on 7.3.2. than this might be a bug > > that should be solved by someone in > > org.mmbase.module.database.support.PostgreSQL72 > > Could you add this bug to the bugtracker <http://www.mmbase.org/bug> ?
postgress masters backward incompatibility very well and with the added value of the jdbc driver that handles blobs in different way's for every version it very hard to support the database. This is not a suprise to me. the "function/stored procedure" here was created because with postgress we use table inheritance but postgress does't handle foreign-keys wel nor do the constraints on inherited tables very well (if in mmbase_object we define number to be unique that does not prevent us from creating other entries with the same number) We need to find a good maintainer for the postgres storage layer and for now it looks like every postgress version will need it's own storage layer.
