Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for Postgres Transactions #470

Open
Fmstrat opened this issue Dec 20, 2019 · 0 comments
Open

Add support for Postgres Transactions #470

Fmstrat opened this issue Dec 20, 2019 · 0 comments
Labels
feature request New issue opened using "Feature request" template

Comments

@Fmstrat
Copy link
Contributor

Fmstrat commented Dec 20, 2019

Is your feature request related to a problem? Please describe.
Unless I am missing something, there is no way to use transactions to interface with Postgres: https://www.postgresql.org/docs/8.3/tutorial-transactions.html

Describe the solution you'd like
The ability to use transactions, for instance, highlight and run:

BEGIN;

Then highlight and run:

SAVEPOINT my_savepoint;
UPDATE accounts SET balance = balance - 100.00 WHERE name = 'Alice';

Then highlight and run:

ROLLBACK TO my_savepoint;
COMMIT;

And have the DB be where it was when it started.

@Fmstrat Fmstrat added the feature request New issue opened using "Feature request" template label Dec 20, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New issue opened using "Feature request" template
Projects
None yet
Development

No branches or pull requests

1 participant