Skip to content

Instantly share code, notes, and snippets.

@ramfjord

ramfjord/prepared_statement_rollback.sql

Created May 6, 2016 07:41
Show Gist options
  • Save ramfjord/7906d846a60f59052604da4a3e391d6b to your computer and use it in GitHub Desktop.
Save ramfjord/7906d846a60f59052604da4a3e391d6b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
prepared_statement_rollback.sql
database=> BEGIN;
BEGIN
database=> PREPARE dumb AS SELECT 'dumb';
PREPARE
database=> ROLLBACK;
ROLLBACK
database=> PREPARE dumb AS SELECT 'dumb';
ERROR: prepared statement "dumb" already exists
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment