Yii2 update column on update, and default value current timestamp in postgres

Question

In yii2 migration file i had create two columns

'updated_at' => $this->integer()->defaultValue('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'),
'created_at' => $this->integer()->defaultValue('CURRENT_TIMESTAMP')

But this is working in MYSQL, and it will not working in PostgreSQL?

How to create column with updating timestamp column when I update the row, and set default timestamp when I create the row.

Michal Hynčica · Accepted Answer · 2019-10-14 14:01:41Z

1

You can use yii\behaviors\TimestampBehavior if you want solution that wouldn't be dependent on used DBMS.

Otherwise you have to use trigger to set the current timestamp on update. See this question for more info Update timestamp when row is updated in PostgreSQL

answered Oct 14, 2019 at 14:01

Michal Hynčica

6,2711 gold badge16 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Yii2 update column on update, and default value current timestamp in postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related