"Vincenzo Romano" <[EMAIL PROTECTED]> writes: >> Or wrap it around SQL function: > > That's the way I'm doind now even if in a slightly different way. > 20+ million calls will badly slooow down the DB insertions
Are you sure? How much? > and require you to know the exact name of the implicit sequence If you're sure you only have a single sequence being bumped here (no triggers inserting somewhere else, or other columns with sequences for default values, etc) then you could use lastval(). > and, more important, not to have any concurrent accesses to it. huh? no, sequences don't require this. They would be pointless if they did. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly