[MonetDB-users] primary key retrieval

Lange Marcus marcus.lange at saabgroup.com
Tue Dec 4 10:21:48 CET 2007


 
> > Hello,
> >
> > How do I retrieve the primary key id value after inserting 
> something 
> > new into the database ?
> 
> Hey Marcus, I had a similar question using python a few days back.
> The subject was "python cursor missing lastrowid attribute?"  
> That might help.
> 
> The basic answer is that this is not supported (due to 
> concurrency issues).  The workaround is to pregenerate PKs 
> using sequences.
> 

Ok, I will have a look at that thread.

Thanks!
/Marcus




More information about the users-list mailing list