pg.ddx.io pgaudit/pgaudit GitHub issues and pull requests
help / color / mirror / Atom feed[pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
6+ messages / 2 participants
[nested] [flat]
* [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2023-02-28 17:31 "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
0 siblings, 0 replies; 6+ messages in thread
From: fabiobaiao (@fabiobaiao) @ 2023-02-28 17:31 UTC (permalink / raw)
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
An
```sql
INSERT INTO "table"("col1", "col2") VALUES ('foo', 'bar') RETURNING "col1";
```
with a
```sql
GRANT SELECT("col2") on TABLE "table" TO "auditor";
```
emits an audit log.
It seems that the `insertedCols` are being checked against both the `INSERT` and `SELECT` grants, whilst I guess it should be checking the latter grant against the `selectedCols`.
^ permalink raw [nested|flat] 6+ messages in thread
* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2023-02-28 17:31 "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
4 siblings, 0 replies; 6+ messages in thread
From: fabiobaiao (@fabiobaiao) @ 2023-02-28 17:31 UTC (permalink / raw)
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
@fabiobaiao renamed this.
^ permalink raw [nested|flat] 6+ messages in thread
* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:39 "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
4 siblings, 0 replies; 6+ messages in thread
From: dwsteele (@dwsteele) @ 2026-06-26 03:39 UTC (permalink / raw)
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
@dwsteele assigned @dwsteele.
^ permalink raw [nested|flat] 6+ messages in thread
* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:39 "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
4 siblings, 0 replies; 6+ messages in thread
From: dwsteele (@dwsteele) @ 2026-06-26 03:39 UTC (permalink / raw)
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
@dwsteele applied label "bug".
^ permalink raw [nested|flat] 6+ messages in thread
* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:45 "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
4 siblings, 0 replies; 6+ messages in thread
From: dwsteele (@dwsteele) @ 2026-06-26 03:45 UTC (permalink / raw)
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
@dwsteele closed this.
^ permalink raw [nested|flat] 6+ messages in thread
* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:45 "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
4 siblings, 0 replies; 6+ messages in thread
From: dwsteele (@dwsteele) @ 2026-06-26 03:45 UTC (permalink / raw)
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
This is fixed in PR #323.
^ permalink raw [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-06-26 03:45 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-28 17:31 [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
2023-02-28 17:31 ` "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
2026-06-26 03:39 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-06-26 03:39 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-06-26 03:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-06-26 03:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox