Re: [HACKERS] Transaction user id through logical decoding

Hi Craig, Thanks for your answer, I'll need to dig deep in the solutions you suggested although I was looking for something less convoluted. Valerio -- View this message in context: http://postgresql.nabble.com/Transaction-user-id-through-logical-decoding-tp5923261p5930219.html Sent from the

Re: [HACKERS] Transaction user id through logical decoding

On 28 Sep. 2016 17:50, "valeriof" wrote: > > Hi all, > I'm developing a custom plugin to stream Postgres CDC changes to my client > application. One of the info the application needs is the user id of the > user who executed a certain transaction. I can see we have

[HACKERS] Transaction user id through logical decoding

Hi all, I'm developing a custom plugin to stream Postgres CDC changes to my client application. One of the info the application needs is the user id of the user who executed a certain transaction. I can see we have access to other transaction info (xid, lsn, changed data) but apparently the user