in reply to Re: Class::DBI::Loader misbehaves (can't find a primary key)
in thread Class::DBI::Loader misbehaves (can't find a primary key)

No, I hadn't. I'd actually have to set up MySQL on my development machine and get it running! Also, the schema would have to be modified to use auto_increment instead of the SERIAL types I use for PostgreSQL.

See the first part of my post. I put the Perl code up as well as the definition for the location table. The person table (the one I was actually intersted in populating in this case) couldn't be a simpler table. 

create table person (
      person_id       SERIAL not null primary key,
      given_name      text not null,
      surname         text not null,
      email_addr      text not null default 'no@email.net'
);

[download]

Peter L. Berghold -- Unix Professional
Peter -at- Berghold -dot- Net; AOL IM redcowdawg Yahoo IM: blue_cowdawg

Replies are listed 'Best First'.
Re^3: Class::DBI::Loader misbehaves (can't find a primary key)
by Melly (Chaplain) on Oct 17, 2006 at 08:37 UTC

    Well, if you post minimal code that reproduces the problem, I can try and test it against mysql, if you don't, I can't.

    I can't reconstruct a program that reproduces the problem from snippets, since I don't have postgresql, and therefore have no way of knowing whether such a reconstructed program would trigger the bug or not against postresql - which would make it a pointless exercise.

    Tom Melly, tom@tomandlu.co.uk
[reply]

In Section Seekers of Perl Wisdom