Postgres Functional Test Bug

I have UserTest where I want to test registration but i get an error: Unique violation: 7 ERROR: duplicate key value violates unique constraint "pkuser_"

I’ve defined fixtures in my UserTestClass:




public $fixtures=array(

		'users'=>':user_',

		'accounts'=>':account',

		'worksystems'=>':workSystem',

		'authassignments'=>':authassignment',

		'employees'=>':employee',

	);



After fixtures are loaded to database sequnce is always set to 1,

so it seems to me that postgres sequences support is invalid.

sequences in postgres are a replacement for auto_increment fields in mysql… Yii does nothing with that… you just don’t insert anything for that field and postgres will give it the next value from the sequence…