Re: [Maypole] Problem with postgresql

2005-09-26 Thread Paulo Silva
On Sun, 2005-09-25 at 20:31 +0100, David Baird wrote: > > Ahah, I see. That was a fix supplied by me a while ago :-). The > problem was that CDBI::Loader takes lots of additional useful options, > which you can pass in the call to setup(), but the old calling > convention blocked that. What you nee

Re: [Maypole] Problem with postgresql

2005-09-25 Thread David Baird
On 9/25/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > On Sun, 2005-09-25 at 14:01 +0100, David Baird wrote: > > On 9/25/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > > That's pretty weird. Your setup call looks like this: > > > > CD->setup('dbi:Pg:dbname=', '', '', {AutoCommit => 1}); > >

Re: [Maypole] Problem with postgresql

2005-09-25 Thread Paulo Silva
On Sun, 2005-09-25 at 14:01 +0100, David Baird wrote: > On 9/25/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > That's pretty weird. Your setup call looks like this: > > CD->setup('dbi:Pg:dbname=', '', '', {AutoCommit => 1}); > > including the curly braces? Yes > What version of Maypol

Re: [Maypole] Problem with postgresql

2005-09-25 Thread David Baird
On 9/25/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > > > Did you set { AutoCommit => 1 } in the connection parameters? > > > > Yes. > > > > Is the Class::DBI::Loader::Pg responsible for using the parameters? > > Maybe there is a chance that the { AutoCommit => 1 } is being ignored > > somewhere? >

Re: [Maypole] Problem with postgresql

2005-09-25 Thread Paulo Silva
> > Did you set { AutoCommit => 1 } in the connection parameters? > > Yes. > > Is the Class::DBI::Loader::Pg responsible for using the parameters? > Maybe there is a chance that the { AutoCommit => 1 } is being ignored > somewhere? I think this was the problem. After manually patching the class

Re: [Maypole] Problem with postgresql

2005-09-25 Thread Paulo Silva
On Sat, 2005-09-24 at 15:52 +0100, David Baird wrote: > On 9/24/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > > On Sat, 2005-09-24 at 13:17 +0100, David Baird wrote: > > > See the Maypole FAQ at http://maypole.perl.org/?FAQ - How do I get > > > beerdb working with Postgres? > > > > I've checked the

Re: [Maypole] Problem with postgresql

2005-09-24 Thread David Baird
On 9/24/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > On Sat, 2005-09-24 at 13:17 +0100, David Baird wrote: > > See the Maypole FAQ at http://maypole.perl.org/?FAQ - How do I get > > beerdb working with Postgres? > > I've checked the connection string and the Class::DBI::Loader::Pg.pm > file and all

Re: [Maypole] Problem with postgresql

2005-09-24 Thread Paulo Silva
On Sat, 2005-09-24 at 13:17 +0100, David Baird wrote: > See the Maypole FAQ at http://maypole.perl.org/?FAQ - How do I get > beerdb working with Postgres? I've checked the connection string and the Class::DBI::Loader::Pg.pm file and all seems ok. It's a strange behavior. If I add/remove an entry

Re: [Maypole] Problem with postgresql

2005-09-24 Thread David Baird
On 9/24/05, Paulo Silva <[EMAIL PROTECTED]> wrote: > Hello, > > I'm starting developing with maypole and I'm having a strange issue with > PostgreSQL. > > I created a site to serve as a simple CD database: > > # > package CD; > use strict; > use warnings;

[Maypole] Problem with postgresql

2005-09-24 Thread Paulo Silva
Hello, I'm starting developing with maypole and I'm having a strange issue with PostgreSQL. I created a site to serve as a simple CD database: # package CD; use strict; use warnings; use base 'Apache::MVC'; use Class::DBI::Loader::Relationship; CD->se