"Greg Sabino Mullane" <g...@turnstep.com> skribis:
>> Im using the Pg back-end of DBI. I have a table like this:
> ...
>> Table "public.builds"
> ...
>> Yet DBI raises this error:
>
>> no sequence found for Builds.id, check the RDBMS table definition or
>> explicitly set the
>> 'sequence' for this column in Builds at
>> /usr/share/perl5/DBIx/Class/Schema.pm line 1026
>> DBIx::Class::Schema::throw_exception('Hydra::Schema=HASH(0x27bbce0)',
>
> Your issue is with DBIx::Class, not DBI. Completely separate beasts. One
> possible
> reason for the error is that you seem to be using "Builds.id", but the
> tablename
> is actually lowercase "builds". psql will show you the lowercased version, but
> your script and/or DBIx::Class::Schema may not.
Indeed, the schema was initially generated for an SQLite DB, and thus
wasn’t consistent with Pg’s case-folding rules.
Thanks for putting me on the right track!
Ludo’.
