U++ forum: Welcome to the forum

Search on this site

Search in forums

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

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

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

Tue, 08 July 2008 15:57

mirek
Messages: 13980
Registered: November 2005

Ultimate Member

zsolt wrote on Mon, 07 July 2008 16:48

I think, GetInsertedId(const char* seqence = 0) would be useful.
MySql and SQLite classes would simply neglect this parameter, PostrgreSQL would use parameter as a sequence name to return "SELECT currval('%s')".

This way we could create portable database software.

Well, I sort of see your argument now, but this is fundamentally broken w.r.t concurency.

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

Mirek

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 May 13 15:30:32 CEST 2024

Total time taken to generate the page: 0.01692 seconds