Re: best way to get autogenerated primary key

Thanks, but there seems to be no Statement class in the Python API. Any search on 'getGeneratedKeys' (google, grep over the source) yields nothing. Is there a way to do it in Python? Mate On Tue, Jan 29, 2013 at 2:47 AM, Percy Wegmann wrote:

The getGeneratedKeys() method on Statement and PreparedStatement should do the trick:

http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#getGenerate...)

Cheers, Percy

On Mon, Jan 28, 2013 at 7:11 PM, Mate Birkas wrote:

...

Hi, this is my first post to this list, so forgive me if this is not the right place to post this. I tried to do my research (google, monetdb.org, python api help) but didn't find an answer.

How can I get the auto-generated primary key (integer) after executing an insert. I want to use it in a second insert to another table that references the first.

(in PostgreSQL I used the RETURNING clause for this)

thanks in advance Mate

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

--

Percy Wegmann +1 512 637 8500 ext 148

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list