Transaction commit/rollback support

supabase-community / postgrest-kt

Postgrest Kotlin Client

53 stars 8 forks source link

Transaction commit/rollback support #5

Closed spleenware closed 2 years ago

spleenware commented 2 years ago

I'm by no means a Postgres expert, but am needing to find out if there is/will be support for transactions? I'm not sure if Supabase has tutorials on this? Or whether this Kotlin library will expose methods for constructing more complex INSERT syntax, with multiple tables involved?

steve-chavez commented 2 years ago

more complex INSERT syntax, with multiple tables involved?

This one needs an upstream feature: https://github.com/PostgREST/postgrest/issues/818.

For now you can use a function and call it through RPC.