I have the following table named values:
id serial user_id integer store_id integer identifier VARCHAR(255) created timestamp without time zone DEFAULT NOW()
But my application has inserted following values:
And that values seem wrong. What I suspect is a replication lag between master and slave alongside with an application termination right just after writing. The application is a web one and I suspect that happens whilst user ferfeshed whilst saving.
Would a transaction could solve the problem or this problem should be tackled at application level?