details: http://code.openbravo.com/erp/devel/main/rev/013bb9c8f5e8 changeset: 4391:013bb9c8f5e8 user: Stefan Hühner <stefan.huehner <at> openbravo.com> date: Wed Jul 29 16:55:40 2009 +0200 summary: Fixed 9140: Speed up delete client on postgres
details: http://code.openbravo.com/erp/devel/main/rev/c142a61447c1 changeset: 4392:c142a61447c1 user: Stefan Hühner <stefan.huehner <at> openbravo.com> date: Wed Jul 29 18:19:07 2009 +0200 summary: Issue 9140: Fix stupid qouting error in last commit diffstat: src-db/database/model/postscript-PostgreSql.sql | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diffs (23 lines): diff -r 5aec74ea40f4 -r c142a61447c1 src-db/database/model/postscript-PostgreSql.sql --- a/src-db/database/model/postscript-PostgreSql.sql Wed Jul 29 12:19:38 2009 +0200 +++ b/src-db/database/model/postscript-PostgreSql.sql Wed Jul 29 18:19:07 2009 +0200 @@ -122,7 +122,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SL -* All portions are Copyright (C) 2001-2008 Openbravo SL +* All portions are Copyright (C) 2001-2009 Openbravo SL * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ @@ -138,7 +138,9 @@ v_seqNo := v_seqNo + 1; INSERT INTO AD_SCRIPT_SQL VALUES (v_seqNo+100000, 'DELETE FROM '||Cur_Constraints.TABLE_NAME||' WHERE '||Cur_Constraints.COLUMN_NAMES|| ' IS NOT NULL AND ' ||Cur_Constraints.COLUMN_NAMES|| - ' NOT IN (SELECT ' ||Cur_Constraints.FK_COLUMN_NAMES || ' FROM ' || Cur_Constraints.FK_TABLE || ')' + ' IN (' || + ' SELECT ' ||Cur_Constraints.COLUMN_NAMES || ' FROM ' || Cur_Constraints.TABLE_NAME || ' EXCEPT ' || + ' SELECT ' ||Cur_Constraints.FK_COLUMN_NAMES || ' FROM ' || Cur_Constraints.FK_TABLE || ')' ); END LOOP; ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits