How to execute an update query only (no RETURNING)

[atoncetti]

Hello,

I cannot find a way to execute a simple UPDATE query without the RETURNING part:

I have tried:

models.Records.Update(input.UpdateMod()).Exec(ctx, bob.Debug(options.Executor))

And

rec, err := models.Records.Query(...).One(ctx, options.Executor)

rec.Update(ctx, bob.Debug(options.Executor), &input.RecordSetter)

Both approaches generate a UPDATE ... RETURNING query and the RETURNING part, for my case, is triggering a RLS SELECT policy that fails.

What is the correct way to do it?

Thank you for your inputs!

bob v0.41.1
go 1.24.0

[stephenafamo]

No way to do this currently. I honestly didn't expect such an edge case.

I'll work on something

[atoncetti]

Thank you for your feedback.

To expand a bit the case above:

RLS is enabled on 'records'
We have 'records' that can be 'public' or 'private'. A 'private' record can only be viewed by its owner.

The problem happens when a user sets a 'public' record to 'private' and sets the owner to someone else (UPDATE operation).

The UPDATE policy succeeds but the … RETURNING fails because the user is not the owner and the whole operation is aborted.

Hope it helps with reasoning for a solution!