Getting: Insufficient Privilege: 7 Error


While running test. I’m getting this exception:


CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42501]: Insufficient privilege: 7 ERROR:  permission denied: "RI_ConstraintTrigger_33494" is a system trigger









Full output can be found in Output window.

Any idea how to fix it.

Database I’m using PostgreSQL 9.1


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.

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 [color=#1C2837][size=3]referential integrity checks every time a new one is added.[/size][/color]