Re: Obtain primary key value generated by before-insert trigger

[Peter Brawley]

> my calling client must be able to retrieve that value, in a thread-safe manner.

In a Trigger, the value is in new.pkcolname where pkcolname is the name of the pk column. The Trigger could post that value to a semaphore table which the client can read whenever.

> I tried running your select after I performed an insert, but the select always returned null.

Well yes, if it's not auto_increment, that will not work.