Re: Limit for an transaction

Matthias Teege wrote:
> 
> Moin,
> 
> ist there any limit for the length of an transaction? I'am
> using postgreSQL 6.5.1 with PHP and the apache log says:
> 
> NOTICE:  (transaction aborted): queries ignored until END

Usually that appears right after one of the queries you
did failed for some reason (usually a typo in the query).
Since the query didn't complete sucessfully it must be aborted,
and this it ignores all queries until END.
-- 
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/