Re: serial autoincrement and related table

 > If you want PostgreSQL to populate your idmember field with the next
 > value from the sequence, you need to specify the keyword DEFAULT as its
 > value or omit it from the INSERT list of coulumns (this assumes you have

I do omit it.

 > DEFAULT nextval('members_idmember_seq') defined on the idmember column).

I use CREATE TABLE "members" (idmember" SERIAL PRIMARY KEY, ...);

 > Should be :
 >
 > Cmd = "SELECT currval('members_idmember_seq');"

Ah, thanks for the shorter syntax.

 > Remember that there's no such thing as auto-increment fields in
 > PostgreSQL - they are SEQUENCES.

I know.

So, it's the best or reasonable practice(TM), isn't it?

--
Milos Prudek