#34434: psycopg 3 cursor.execute no longer accepts Python tuple binding
-------------------------------------+-------------------------------------
Reporter: David Burke | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution: invalid
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):
* cc: Florian Apolloner, Simon Charette (added)
* status: new => closed
* resolution: => invalid
Comment:
Replying to [ticket:34434 David Burke]:
> This may be a bug or a missing feature of psycopg 3. If expected, it may
be worth mentioning as a breaking change when using psycopg3.
Thanks for the ticket. This is a backward incompatibility change
explicitly stated in `psycopg`
[https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html#you-cannot-use-
in-s-with-a-tuple docs] (there are other small
[https://www.psycopg.org/articles/2020/11/24/psycopg3-adaptation/ caveats]
when using raw SQL statements). It's not something that we want/can change
in Django itself. Moreover, it crashes with other backends so it's now
more consistent.
We normally don't document backward incompatibility changes in database
adapters, especially on a low-level of executing raw SQL statements. We
don't want to copy `psycopg` 3 docs here. I think your ticket will be
enough to raise awareness on this small inconvenience.
--
Ticket URL: <https://code.djangoproject.com/ticket/34434#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/01070187124b146c-fd9b54ec-8985-449a-baab-19968fd2843e-000000%40eu-central-1.amazonses.com.
