<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej" -->

---
title: PostgreSQL adapter for Python | daily.dev
description: Psycopg 2.4.6, a bugfix release of the popular PostgreSQL adapter for Python, has been published. No new features are introduced, but numerous fixes address...
canonical: https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: PostgreSQL adapter for Python | daily.dev
og:description: Psycopg 2.4.6, a bugfix release of the popular PostgreSQL adapter for Python, has been published. No new features are introduced, but numerous fixes address...
og:url: https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej
og:image: https://api.daily.dev/og/posts/sYkKeXsEj.png
og:image:alt: PostgreSQL adapter for Python
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL adapter for Python

**[Psycopg](https://daily.dev/sources/psycopg)** · 2 min read · 0 upvotes · 0 comments

## Summary

Psycopg 2.4.6, a bugfix release of the popular PostgreSQL adapter for Python, has been published. No new features are introduced, but numerous fixes address issues in copy operations, adaptation, cursor handling, and stability. The most significant fixes target the Zope adapter, including a broken connection pool and re-initialization problems across ZSQL methods, so users on prior 2.4.x versions with Zope are urged to upgrade promptly. Other fixes cover GIL handling crashes, pickling of FixedOffsetTimezone, DictRow and RealDictRow objects, empty string handling in composite casters, and exception handling in connect().

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.psycopg.org/articles/2012/12/12/psycopg-246-released>

## Questions this post answers

### What is fixed in Psycopg 2.4.6 for Zope users?

Psycopg 2.4.6 fixes a broken connection pool for Zope and resolves connection re-initialization issues across ZSQL methods within the same request, addressed in tickets #123, #125, and #142. Zope users running earlier 2.4.x versions of psycopg are encouraged to update to 2.4.6 promptly to avoid these connection handling problems.

_daily.dev helps developers maintaining Zope and PostgreSQL stacks keep up with adapter patch releases._

### Does psycopg 2.4.6 add any new features?

No, psycopg 2.4.6 is strictly a bugfix release with no new features introduced. It corrects issues in copy operations, type adaptation, extra cursor usage, and overall stability, alongside fixes for pickling of FixedOffsetTimezone, DictRow, and RealDictRow objects.

_Track dependency patch releases like this on daily.dev before upgrading production Python and PostgreSQL code._

### What GIL-related crash was fixed in psycopg 2.4.6?

Psycopg 2.4.6 dropped the GIL release during string adaptation around a function call that invoked a Python API function, which could previously cause the interpreter to crash. It also changed the code to release the GIL around PQgetResult calls after COPY operations, per tickets #110 and #140.

_Developers debugging obscure interpreter crashes can follow database driver fixes like this via daily.dev._

---

Tags: [#python](https://daily.dev/tags/python), [#postgresql](https://daily.dev/tags/postgresql)

[View this post on daily.dev](https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"PostgreSQL adapter for Python","url":"https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej"},"datePublished":"2026-08-23T12:22:24.295Z","dateModified":"2026-08-23T12:47:32.167Z","description":"Psycopg 2.4.6, a bugfix release of the popular PostgreSQL adapter for Python, has been published. No new features are introduced, but numerous fixes address...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b0cbd2ac8948f96ab39fa6a90db7464f?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b0cbd2ac8948f96ab39fa6a90db7464f?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Psycopg","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Psycopg","logo":"https://media.daily.dev/image/upload/s--5N-KNNWk--/f_auto,q_auto/v1787487485/logos/psycopg?_a=BAMAMicg0","url":"https://daily.dev/sources/psycopg"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"python,postgresql","timeRequired":"PT2M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Psycopg","item":"https://daily.dev/sources/psycopg"},{"@type":"ListItem","position":3,"name":"PostgreSQL adapter for Python"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/postgresql-adapter-for-python-sykkexsej#faq","mainEntity":[{"@type":"Question","name":"What is fixed in Psycopg 2.4.6 for Zope users?","acceptedAnswer":{"@type":"Answer","text":"Psycopg 2.4.6 fixes a broken connection pool for Zope and resolves connection re-initialization issues across ZSQL methods within the same request, addressed in tickets #123, #125, and #142. Zope users running earlier 2.4.x versions of psycopg are encouraged to update to 2.4.6 promptly to avoid these connection handling problems. daily.dev helps developers maintaining Zope and PostgreSQL stacks keep up with adapter patch releases."}},{"@type":"Question","name":"Does psycopg 2.4.6 add any new features?","acceptedAnswer":{"@type":"Answer","text":"No, psycopg 2.4.6 is strictly a bugfix release with no new features introduced. It corrects issues in copy operations, type adaptation, extra cursor usage, and overall stability, alongside fixes for pickling of FixedOffsetTimezone, DictRow, and RealDictRow objects. Track dependency patch releases like this on daily.dev before upgrading production Python and PostgreSQL code."}},{"@type":"Question","name":"What GIL-related crash was fixed in psycopg 2.4.6?","acceptedAnswer":{"@type":"Answer","text":"Psycopg 2.4.6 dropped the GIL release during string adaptation around a function call that invoked a Python API function, which could previously cause the interpreter to crash. It also changed the code to release the GIL around PQgetResult calls after COPY operations, per tickets #110 and #140. Developers debugging obscure interpreter crashes can follow database driver fixes like this via daily.dev."}}]}
```

