in reply to Re^3: Need help with DBD::Pg
in thread Need help with DBD::Pg
nextvalAdvance the sequence object to its next value and return that value. This is done atomically: even if multiple sessions execute nextval concurrently, each will safely receive a distinct sequence value.
currval
Return the value most recently obtained by nextval for this sequence in the current session. (An error is reported if nextval has never been called for this sequence in this session.) Notice that because this is returning a session-local value, it gives a predictable answer whether or not other sessions have executed nextval since the current session did.
About my problem:
I'm rewriting everything using:
use DBI qw(:sql_types); ..... $sth->bind_param(1,undef,SQL_....); $sth->execute(<values>);
and spliting the multiple statements I have.
Thanks,
Miguel
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^5: Need help with DBD::Pg
by eclark (Scribe) on Feb 24, 2005 at 17:36 UTC |