Announcing our $32 million Series B
Changelog 4/08/22: Transaction mode and RETURNING in Postgres

1 min read

Changelog 4/08/22: Transaction mode and RETURNING in Postgres

Written by

Madhura Kumar

Published on

Apr 8, 2022

Airplane lets you transform scripts, APIs, and SQL queries into apps for your team in minutes. If you have feature requests you'd like to see in future changelogs, reply and let us know!

This week we rolled out transaction mode and support for RETURNING in Postgres is now live.

Transaction mode

With the introduction of transaction mode, you now have the ability to choose what kind of transaction (auto, read-only, read/write, no transaction) to use on your task. By default you can select "auto" and let Airplane decide, or you can explicitly choose a transaction mode. If a transaction is used, it is committed only if all queries successfully execute. You can see the effective transaction mode in the task logs.

You can read more about transaction mode in our SQL docs: Parameters and query arguments

RETURNING in Postgres

We now support RETURNING clauses in Postgres. Running INSERT, UPDATE, or DELETE queries with RETURNING clauses will now display the returned rows in the outputs.

Share this article:

Subscribe to new blog posts from Airplane.