Re: CDBI::Loader::Pg

[prev] [thread] [next] [Date index for 2004/12/28]

Sean Davis wrote:
> In answer to my own question, I see that I need to call dbi_commit() if 
> I have AUTOCOMMIT off (which it is by default in Pg).  Is there a way to 
> pass the AUTOCOMMIT parameter to DBI using CDBI::Loader?

__PACKAGE__->connection($dsn, $user, $pass, {AutoCommit => 1});

AutoCommit is enabled by default unless the driver is Oracle or Pg.

--simonflk

> Thanks,
> Sean
> 
> On Dec 28, 2004, at 4:46 PM, Sean Davis wrote:
> 
>> I am interested in using CDBI::Loader::Pg (or CDBI::Pg?).  However, I 
>> can't find a way to update the table in Pg.  If I do an explicit 
>> update, I still do not get a database entry after creating the object. 
>>  What am I missing (probably a good deal)?
>>
>> Thanks,
>> Sean