[ic] Sequences and postgres bug found

René Hertell interchange-users@icdevgroup.org
Thu Jul 18 14:52:00 2002


I found now what causes the sequence problem i wrote earlier today..

When specifying a serial column in postgres, ic creates a table called
ic_test_create. Postgres makes from it sequence called
ic_test_create_code_seq. This should also be deleted when the test-table
creation process is sucessful (in the DBI.pm module there is no "drop
sequence" part at all).

I tried to add this to the DBI.pm (row 289 and 299)

    $db->do("drop sequence ic_test_create_code_seq")

to that part that deletes the test-table, but it IC somehow fails to execute
it.

Could someone help me with insering the "drop sequence" to the DBI.pm so
that this issue could be fixed.

REgards, René