diff options
| author | Raphael Collet <rco@openerp.com> | 2012-03-19 10:21:42 +0100 |
|---|---|---|
| committer | Raphael Collet <rco@openerp.com> | 2012-03-19 10:21:42 +0100 |
| commit | cd47a2fcaf70c4f8de970779b2dd98979b2152d7 (patch) | |
| tree | 0b088201dc885d34955274612b4281d3ee774c9b /openerp/tools/sql.py | |
| parent | 8f8b5497d124fd553e6a44a21fca1eccca42d0f8 (diff) | |
| parent | b7f4423ced6c43d452d84c2398f17de5a1a1bc80 (diff) | |
[MERGE] from trunk
bzr revid: rco@openerp.com-20120319092142-bk2yjoao67g712nb
Diffstat (limited to 'openerp/tools/sql.py')
| -rw-r--r-- | openerp/tools/sql.py | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/openerp/tools/sql.py b/openerp/tools/sql.py index 445eebb0bb8..3397d1ecbd3 100644 --- a/openerp/tools/sql.py +++ b/openerp/tools/sql.py @@ -20,9 +20,7 @@ ############################################################################## def drop_view_if_exists(cr, viewname): - cr.execute("select count(1) from pg_class where relkind=%s and relname=%s", ('v', viewname,)) - if cr.fetchone()[0]: - cr.execute("DROP view %s" % (viewname,)) - cr.commit() + cr.execute("DROP view IF EXISTS %s CASCADE" % (viewname,)) + cr.commit() # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: |