[aljarry]

Interesting note on the NOW() (or CURRENT_TIMESTAMP), they are equivalent to transaction_timestamp(), which means - start time of the current transaction.

So, if you'd insert multiple items in a single transaction, all of them would end up with the same value in the "created" column.

[timbaboon]

This caused so many issues in one of our systems. Lesson learnt :)

[ctxc]

Thanks, great comment. TIL.