[Dbix-class] last insert id problem with Oracle

Brandon Black blblack at gmail.com
Tue Jul 11 21:17:00 CEST 2006


On 7/11/06, Tony Lincoln <AHLincoln at lbl.gov> wrote:
> Well, I had changed the id field's case in update_or_create because
> PK::Auto wouldn't increment it when it was lowercased, and I had sort of

Just to keep our language clear: PK::Auto doesn't increment anything.
Your database vendor handles all the autoincrementing in its normal
everyday fashion, using triggers or what-have-you.  The DBIx::Class
"PK::Auto" component's purpose in life is to fetch the newly
incremented and inserted value from the database library/interface
after the fact, and copy it correctly into the Perl object
representation of the new row.

-- Brandon



More information about the Dbix-class mailing list