Multiple requests in a transaction #286
Description
I have a schema capturing events and participants:
CREATE TABLE demo.participant(
id BIGINT DEFAULT,
name VARCHAR(255) NOT NULL
);
CREATE TABLE demo.event(
id BIGINT DEFAULT,
title VARCHAR(255) NOT NULL
);
CREATE TABLE demo.event_participant(
event_id BIGINT NOT NULL REFERENCES demo.event(id),
participant_id BIGINT NOT NULL REFERENCES demo.participant(id),
PRIMARY KEY(event_id,participant_id)
);
I can expose these tables directly with 3 postgrest views. However, I required that inserting/updating an event and the participants in that event should be atomic.
I think I need a single view that somehow data from event and event_participant, and is insertable/updateable.
Is there any way to do this with postgrest?