Re: PostgreSQL: "no sequence found"

"Greg Sabino Mullane" <[email protected]> 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’.