U++ framework: U++ SQL » PostgreSQL GetInsertedId()

Home » U++ Library support » U++ SQL » PostgreSQL GetInsertedId()

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: PostgreSQL GetInsertedId() [message #16723 is a reply to message #16720]

Tue, 08 July 2008 16:56

zsolt
Messages: 704
Registered: December 2005
Location: Budapest, Hungary

Contributor

luzr wrote on Tue, 08 July 2008 15:57

What if other client inserts a record between your INSERT and SELECT?

In PostgreSQL, curval returns the value after last "nextval" in current session.
If some other clients call "nextval" after yours, you will see your original value got from your last "nextval".

Report message to a moderator

[Message index]

		PostgreSQL GetInsertedId() By: captainc on Wed, 02 July 2008 16:34
		Re: PostgreSQL GetInsertedId() By: captainc on Wed, 02 July 2008 16:46
		Re: PostgreSQL GetInsertedId() By: mirek on Wed, 02 July 2008 23:17
		Re: PostgreSQL GetInsertedId() By: captainc on Thu, 03 July 2008 13:48
		Re: PostgreSQL GetInsertedId() By: mirek on Fri, 04 July 2008 13:49
		Re: PostgreSQL GetInsertedId() By: captainc on Mon, 07 July 2008 19:45
		Re: PostgreSQL GetInsertedId() By: unodgs on Mon, 07 July 2008 22:15
		Re: PostgreSQL GetInsertedId() By: mirek on Mon, 07 July 2008 22:17
		Re: PostgreSQL GetInsertedId() By: unodgs on Mon, 07 July 2008 22:46
		Re: PostgreSQL GetInsertedId() By: zsolt on Mon, 07 July 2008 22:49
		Re: PostgreSQL GetInsertedId() By: mirek on Tue, 08 July 2008 07:22
		Re: PostgreSQL GetInsertedId() By: zsolt on Tue, 08 July 2008 08:55
		Re: PostgreSQL GetInsertedId() By: zsolt on Mon, 07 July 2008 22:48
		Re: PostgreSQL GetInsertedId() By: mirek on Tue, 08 July 2008 15:57
		Re: PostgreSQL GetInsertedId() By: zsolt on Tue, 08 July 2008 16:56
		Re: PostgreSQL GetInsertedId() By: captainc on Tue, 08 July 2008 21:58

Previous Topic:	Quick explanation of function calls for postgresql
Next Topic:	db access to MS ACCESS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 20 23:01:58 GMT+2 2026

Total time taken to generate the page: 0.00639 seconds