[SQLObject] test_sqlobject.py fails on Postgres 7.2

[Oleg B. <ph...@ph...>]

Hello!

   ProgrammingError: ERROR:  Relation 'test_s_o1_id_seq' already exists

   I found the cause for this. In 7.2 DROP TABLE drops the table and all
indicies but not sequences.

$ psql test
test=# \d
          List of relations
       Name       |   Type   | Owner 
------------------+----------+-------
 test_s_o1        | table    | phd
 test_s_o1_id_seq | sequence | phd
(2 rows)

test=# DROP TABLE test_s_o1;
DROP
test=# \d
          List of relations
       Name       |   Type   | Owner 
------------------+----------+-------
 test_s_o1_id_seq | sequence | phd
(1 row)


   Can anybody running Postgres 7.3+ confirm whether it drops sequences on
DROP TABLE?

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.