PostgreSQL: “no sequence found”

[Ludovic Courtès]

Hi,

I’m using the Pg back-end of DBI.  I have a table like this:

--8<---------------cut here---------------start------------->8---
hydra=> \d Builds
                              Table "public.builds"
     Column      |  Type   |                      Modifiers                     
 
-----------------+---------+-----------------------------------------------------
 id              | integer | not null default nextval('builds_id_seq'::regclass)
[...]

hydra=> \d builds_id_seq
        Sequence "public.builds_id_seq"
    Column     |  Type   |        Value        
---------------+---------+---------------------
 sequence_name | name    | builds_id_seq
 last_value    | bigint  | 6765
 start_value   | bigint  | 1
 increment_by  | bigint  | 1
[...]
--8<---------------cut here---------------end--------------->8---

Yet DBI raises this error:

--8<---------------cut here---------------start------------->8---
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)', 
'no sequence found for Builds.id, check the RDBMS table defini...') called at 
/usr/share/perl5/DBIx/Class/Storage.pm line 123
        
DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::Pg=HASH(0x275d798)',
 'no sequence found for Builds.id, check the RDBMS table defini...') called at 
/usr/share/perl5/DBIx/Class/Storage/DBI/Pg.pm line 72
        
DBIx::Class::Storage::DBI::Pg::_dbh_get_autoinc_seq('DBIx::Class::Storage::DBI::Pg=HASH(0x275d798)',
 'DBI::db=HASH(0x2c08fe0)', 'DBIx::Class::ResultSource::Table=HASH(0x283dc10)', 
'id') called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 607
        
DBIx::Class::Storage::DBI::dbh_do('DBIx::Class::Storage::DBI::Pg=HASH(0x275d798)',
 '_dbh_get_autoinc_seq', 'DBIx::Class::ResultSource::Table=HASH(0x283dc10)', 
'id') called at /usr/share/perl5/DBIx/Class/Storage/DBI/Pg.pm line 28
        
DBIx::Class::Storage::DBI::Pg::last_insert_id('DBIx::Class::Storage::DBI::Pg=HASH(0x275d798)',
 'DBIx::Class::ResultSource::Table=HASH(0x283dc10)', 'id') called at 
/usr/share/perl5/DBIx/Class/Row.pm line 347
--8<---------------cut here---------------end--------------->8---

Any idea what I’m doing wrong?

This is with PostgreSQL 8.4.14-0ubuntu10.04, DBIx 0.08115-1, on
Trisquel GNU/Linux 4.0.

Thanks,
Ludo’.