---
name: "rollback"
section: "7l"
platform: "linux"
package: "postgresql-client"
version: "7.2.1-2woody8"
release: "Debian 3.0 (Woody)"
platforms: ["linux"]
url: "https://new.carta.tech/rollback/7l"
---

# rollback(7l)

abort the current transaction

## NAME

ROLLBACK - abort the current transaction

## SYNOPSIS

```
ROLLBACK [ WORK | TRANSACTION ]

```

### INPUTS

None.

### OUTPUTS

- **ABORT**

  Message returned if successful.

- **NOTICE: ROLLBACK: no transaction in progress**

  If there is not any transaction currently in progress.

## DESCRIPTION

**ROLLBACK** rolls back the current transaction and causes all the updates made by the transaction to be discarded.

### NOTES

Use COMMIT \[**commit**(l)\] to successfully terminate a transaction. ABORT \[**abort**(l)\] is a synonym for **ROLLBACK**.

## USAGE

To abort all changes:

```
ROLLBACK WORK;

```

## COMPATIBILITY

### SQL92

SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise full compatibility.