On Tue, Sep 25, 2012 at 10:07:43AM -0700, Maximiliano Robaina wrote:

> Hi,
>
> I built a custom django project (django 1.5) to do some custom test. Running that test I get a ProgrammingError: Transaction object is not active.
>
> The strange thing here is this error happen after of execution of several DML statements, but more precisely when it try to reset a sequence (generator):
>
> SELECT gen_id("DJANGO_SITE_SQ", coalesce(max("ID"), 0) - gen_id("DJANGO_SITE_SQ", 0) ) FROM "DJANGO_SITE";
>
> I don't know if this is the problem because that statement is executed several times before without any problem.
>
>
> Where can I to start to research this problem?
>
> Using fdb 0.8.5, Firebird 2.5, Ubuntu 11.04

This seems to be a design issue

http://article.gmane.org/gmane.comp.db.firebird.python/166/