"Vincenzo Romano" <vincenzo.romano@xxxxxxxxx> 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
