rowstile playground

loading Python and Postgres…
Policypolicy.authz
loading…

The tests run here once Python and Postgres have loaded.

user:1, bot:7, or empty for nobody
Runs as the app role, filtered by row-level security, and is rolled back. A COMMIT or ROLLBACK in it ends that transaction early: what it wrote stays until the next edit, and what follows runs signed in as nobody. A RESET ROLE makes the rest run as the owner, who sees every row. The answer says when either happened. One thing differs from a server: this Postgres has a single session, the owner's, so a statement here may set authz.user_id itself. On a server the app role's session is believed only after authz.act_as().

A mistake's code (like AZ203) opens its page here.