PostgreSQL 8.2.7 and 8.3.1 are not recommended for developing Openbravo ERP, and they must not be used to commit any database changes to the SVN trunk repository. The reason is that in both versions pg_get_ruledef() doesn't parenthesize negative constants. Please use 8.2.9 and 8.3.3 instead. Quoting an official note [1]:
"Before this fix, a negative constant in a view or rule might be dumped as, say, -42::integer, which is subtly incorrect: it should be (-42)::integer due to operator precedence rules. Usually this would make little difference, but it could interact with another recent patch to cause PostgreSQL to reject what had been a valid SELECT DISTINCT view query. Since this could result in pg_dump output failing to reload, it is being treated as a high-priority fix. The only released versions in which dump output is actually incorrect are 8.3.1 and 8.2.7." An example of an affected view: src-db/database/model/views/C_INVOICE_V.xml Juan Pablo [1] http://www.postgresql.org/docs/8.3/static/release-8-3-3.html ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Openbravo-development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-development
