Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
Handle CONSTRAINT TRIGGER on DB Manager/PostgreSQL.
Fixes #35967
  • Loading branch information
espinafre committed Apr 24, 2020
1 parent 9183f7b commit 689bcc6
Showing 1 changed file with 1 addition and 1 deletion.
2 changes: 1 addition & 1 deletion python/plugins/db_manager/db_plugins/postgis/connector.py
Expand Up @@ -657,7 +657,7 @@ def getTableConstraints(self, table):
LEFT JOIN pg_class t ON c.conrelid = t.oid
LEFT JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_namespace nsp ON t.relnamespace = nsp.oid
WHERE t.relname = %s %s """ % (con_col_name, self.quoteString(tablename), schema_where)
WHERE c.contype <> 't' AND t.relname = %s %s """ % (con_col_name, self.quoteString(tablename), schema_where)

c = self._execute(None, sql)
res = self._fetchall(c)
Expand Down

0 comments on commit 689bcc6

Please sign in to comment.