Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

ROLLBACK

Name

ROLLBACK -- Aborts the current transaction block and abandons any modifications it would have made.

Synopsis

ROLLBACK [ WORK | TRANSACTION ]

Parameters

WORK | TRANSACTION

A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.

Results

ABORT

The message returned when a transaction is aborted successfully.

NOTICE: ROLLBACK: no transaction in progress

The notice returned if there is not a transaction in progress to rollback.

Description

Use ROLLBACK to abort a transaction in progress and discard all changes either already made or queued to be made on COMMIT.

Example

The following example demonstrates how to rollback an accidental delete performed within a transaction block:

booktown=# 
BEGIN WORK;

BEGIN
booktown=# 
DELETE FROM shipments;

DELETE 36
booktown=# 
ROLLBACK WORK;

ROLLBACK
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire