[VINAY Kr. SHARMA]

Hello,

While running test. I'm getting this exception:

TermTest::testIndex()
CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42501]: Insufficient privilege: 7 ERROR:  permission denied: "RI_ConstraintTrigger_33494" is a system trigger
/var/www/yii/framework/db/CDbCommand.php:357
/var/www/yii/framework/db/schema/pgsql/CPgsqlSchema.php:96
/var/www/yii/framework/test/CDbFixtureManager.php:234
/var/www/yii/framework/test/CDbFixtureManager.php:115
/var/www/yii/framework/test/CDbFixtureManager.php:87
/var/www/yii/framework/base/CModule.php:387
/var/www/yii/framework/test/CDbTestCase.php:85
/var/www/yii/framework/test/CDbTestCase.php:117

Full output can be found in Output window.

Any idea how to fix it.

Database I'm using PostgreSQL 9.1

Thanks

[kokomo]

Grant your yii db user (specified in config) the rights to execute the RI_ConstraintTrigger_33494.

Don't know without your relevant test code why this system trigger is fired.

[VINAY Kr. SHARMA]

kokomo, on 30 January 2013 - 04:11 AM, said:

Grant your yii db user (specified in config) the rights to execute the RI_ConstraintTrigger_33494.

Don't know without your relevant test code why this system trigger is fired.

Thanks it works.

[Todd C]

A good explanation of this problem and a workaround by extending CPgsqlSchema can be found in the thread at the link below. I'm mentioning it here because I think it's a better solution than granting rights to individual referential integrity checks every time a new one is added.


http://www.yiiframew...strainttrigger/