details: https://code.openbravo.com/erp/devel/pi/rev/f5adc2a709a6
changeset: 34901:f5adc2a709a6
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Wed Oct 24 10:31:04 2018 +0200
summary: fixed bug 39516: false local changes positive restoring PG 9.3 dump
on PG 10
After restoring in PG 10 a DB dump taken in PG 9.3, first update.database run
incorrectly detects local changes.
This was caused by many new functions added in PG 10 to trigram extension,
those
functions were unnecessarily included in the model checksum used to check if
there are local changes.
Now those functions are excluded: as dbsm only supports plsql functions, we
now
filter out all the ones implemented by binary code, which is how typically
extension functions are implemented.
diffstat:
src-db/database/model/prescript-PostgreSql.sql | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r 81abb68df45a -r f5adc2a709a6
src-db/database/model/prescript-PostgreSql.sql
--- a/src-db/database/model/prescript-PostgreSql.sql Mon Oct 22 14:27:12
2018 +0200
+++ b/src-db/database/model/prescript-PostgreSql.sql Wed Oct 24 10:31:04
2018 +0200
@@ -1311,6 +1311,7 @@
where pronamespace = n.oid and n.nspname=current_schema()
and p.oid not in (select tgfoid from pg_trigger)
and p.proname not in ('temp_findinarray', 'ad_db_modified',
'dateformat')
+ and p.probin is null
order by 1,2,3,4) loop
--note that for overloaded functions more than one line will be obtained
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
