{"action":"closed","issue":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/10885","repository_url":"https://api.github.com/repos/yiisoft/yii2","labels_url":"https://api.github.com/repos/yiisoft/yii2/issues/10885/labels{/name}","comments_url":"https://api.github.com/repos/yiisoft/yii2/issues/10885/comments","events_url":"https://api.github.com/repos/yiisoft/yii2/issues/10885/events","html_url":"https://github.com/yiisoft/yii2/issues/10885","id":134303978,"number":10885,"title":"InitDbFixture pgsql problem","user":{"login":"rad8329","id":5356143,"avatar_url":"https://avatars.githubusercontent.com/u/5356143?v=3","gravatar_id":"","url":"https://api.github.com/users/rad8329","html_url":"https://github.com/rad8329","followers_url":"https://api.github.com/users/rad8329/followers","following_url":"https://api.github.com/users/rad8329/following{/other_user}","gists_url":"https://api.github.com/users/rad8329/gists{/gist_id}","starred_url":"https://api.github.com/users/rad8329/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rad8329/subscriptions","organizations_url":"https://api.github.com/users/rad8329/orgs","repos_url":"https://api.github.com/users/rad8329/repos","events_url":"https://api.github.com/users/rad8329/events{/privacy}","received_events_url":"https://api.github.com/users/rad8329/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-17T15:04:24Z","updated_at":"2016-02-17T15:12:05Z","closed_at":"2016-02-17T15:12:05Z","body":"When TestCase setup the DbFixtures check the integrity, for that, get all the table names, and execute a command like this `ALTER TABLE \"public\".\"auth_assignment\" DISABLE TRIGGER ALL; ` is a problem, because the method `findTableNames` [https://github.com/yiisoft/yii2/blob/master/framework/db/pgsql/Schema.php](https://github.com/yiisoft/yii2/blob/master/framework/db/pgsql/Schema.php) get all the objects names (including the views), them, when execute the statement for check integrity fail."}}