topic Re: Getting last inserted id for each row in postgres in Talend Studio

Getting last inserted id for each row in postgres

Anonymous — Sun, 30 Mar 2014 17:16:14 GMT

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

Re: Getting last inserted id for each row in postgres

Anonymous — Sun, 30 Mar 2014 21:15:15 GMT

I've just found a topic that describes a similar requirement and also suggest a solution:
https://community.talend.com/t5/Design-and-Development/handling-ID-generation-and-auto-increament/td-p/80518
it this is solved than.

Re: Getting last inserted id for each row in postgres

Anonymous — Mon, 31 Mar 2014 07:56:16 GMT

Hi eliott100,
Thanks for your feedback. Could you please mark this post as resolved?
Best regards
Sabrina