Quantcast

Using QuerySet.iterator() with pgBouncer leads to nonexistent cursor errors (#28062)

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Using QuerySet.iterator() with pgBouncer leads to nonexistent cursor errors (#28062)

Tim Graham-2
Django 1.11 added support for server-side cursors on PostgreSQL:
https://github.com/django/django/commit/f3b7c059367a4e82bbfc7e4f0d42b10975e79f0c

As reported in https://code.djangoproject.com/ticket/28062, pgBouncer doesn't support using WITH HOLD cursors in transaction pooling mode, so the change is backwards incompatible for this configuration.There's some discussion on the ticket about possible solutions, but I wanted to try to bring more attention to this issue to see if anyone else has some expertise to offer.

Thanks!

--
You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/django-developers.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/0b52c8a9-2435-4b8a-92d2-f27c635749a1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...