How to rollback my delete data in Postgres after delete operation?

Question

I have not done anything. I just run this command DELETE FROM feed_republic. But I want to get my data again. What should I do?

When I run rollback I am getting the following message. Please help!

WARNING:  there is no transaction in progress

I have not used any commit or any other command unlike this question Can I rollback a transaction I've already committed? (data loss).

I have not used commit command. So, my database is commited ot not? — Mr.Robot
– Mr.Robot, Commented Mar 14, 2019 at 6:32
I'm afraid, there's no straightforward way to bring data back. I hope you have not done that in production. I believe you're new to Postgres. It's not like Oracle that by default dmls can be rolled back when run as a single statement. In Postgres, a statement is automatically committed unless you're running those inside a transaction, starting with BEGIN; — Kaushik Nayak
– Kaushik Nayak, Commented Mar 14, 2019 at 6:32
It's committed. You performed your operation outside the scope of a transaction, so it's committed automatically. — Robby Cornelissen
– Robby Cornelissen, Commented Mar 14, 2019 at 6:33

Laurenz Albe · Accepted Answer · 2019-03-14 08:33:25Z

1

PostgreSQL is running in autocommit mode, so every statement is running in its own transaction unless you explicitly start a transaction with BEGIN or START TRANSACTION.

The only way you can get your data back is by restoring from a backup.

answered Mar 14, 2019 at 8:33

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

How to rollback my delete data in Postgres after delete operation?

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