#2711: [PATCH] PostgreSQL schema support
-------------------------------------+--------------------------------------
 Reporter:  [EMAIL PROTECTED]  |        Owner:  cmlenz  
     Type:  enhancement              |       Status:  assigned
 Priority:  normal                   |    Milestone:  0.10    
Component:  general                  |      Version:  devel   
 Severity:  normal                   |   Resolution:          
 Keywords:                           |  
-------------------------------------+--------------------------------------
Comment (by pacopablo):

 Ok, with the help of cmlenz, I was able to narrow down the changes a
 little.

 The issue turns out to be that the {{{search_path}}} is lost on a
 {{{rollback()}}}.  Because of connection pooling, it appears that there
 are instances where a connection which has called {{{rollback()}}} get
 used again.  However, the {{{search_path}}} isn't set because a cursor is
 being reused.

 Anyway, the solution in the r3248 patch is to overload {{{rollback()}}}
 and set the {{{search_path}}} after a rollback happens.

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2711>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Reply via email to