Hi!
This has been discussed many times, but I couldn't find the solution for the exact use case, so any help is appreciated.
So after each row of an insert i'd like to somehow get back the current value of the sequence that was used for the insert, to use in in later tPostgressqlOutput components.
Simplified requirement: Start->Insert User->Insert role for given user
I have done much more complicated things, so I am really stunned why I can't find out the solution myself. For me it is strange that tPostgressqlOutput does not support inserts that return a value.
thanks
eliott