Re: Postgresql transaction error

2011-03-22 Thread cootetom
Thanks for the replies. Looking in the log files got me back on track. There was a SQL query running against the database that would never work due to the table to existing. Now i know where to look next time! On Mar 22, 5:42 pm, Jason Culverhouse wrote: > On Mar 22, 2011, at 10:03 AM, cootetom

Re: Postgresql transaction error

2011-03-22 Thread Simon Riggs
On Tue, Mar 22, 2011 at 5:03 PM, cootetom wrote: > Hi, I've been trying to use Postgresql because I'm thinking of using > that instead of MySQL due to it's ability to role back transactions > making it easier to use South. However I've hit a wall with it and > can't seem to fix it. > > I'm using

Re: Postgresql transaction error

2011-03-22 Thread Jason Culverhouse
On Mar 22, 2011, at 10:03 AM, cootetom wrote: > I'm using the psycopg2 python library and have tried postgresql 8 and > now 9. > > The error, in brief, is: > > " > Template error > In template c:\python26\lib\site-packages\django\contrib\admin > \templates\admin\base.html, error at line 58 > Caug

Re: Postgresql transaction error

2011-03-22 Thread Shawn Milochik
pdb: www.doughellmann.com/PyMOTW/pdb/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com.

Re: Postgresql transaction error

2011-03-22 Thread Shawn Milochik
The cause is that there's a problem with a line of code that interacts with the database, leaving the database connection dirty and unusable. The error occurs not at that line of code, but at the next line of code which tries to use the database connection. The solution is to use pdb and/or loggi