psycopg2

psycopg2 copied to clipboard

Encoding question: SystemError: 'cp1252', Python 3.5, psycopg2 '2.6.1 (dt dec pq3 ext lo64)'

4

Is there an explicit encoding requirement that I need to set? Thanks cur.execute("""CREATE DATABASE IF NOT EXISTS TEST""") **\* SystemError: decoding with 'cp1252' codec failed (SystemError: returned a result with...

apiszcz

Interval literals with year/months have different number of seconds w.r.t. Python

2

`select '-1 year -2 mons +3 days -04:05:06'::interval` doesn't return the correct value in Python

dvarrazzo

SegFault while trying to load binary into database

5

Python Version: 2.6.6 Postgresql Version: 9.4.4 Psycopg2 Version: 2.6.1 I've been working on a script that uses psycopg2's binary function to convert and store it in the database in a...

asenabouth

The function psycopg2.extras.register_composite doesn't regard the search path

1

**Please complete the following information:** - OS: Linux 5.10.0-13-amd64 - Psycopg version: 2.9.3 - Python version: 3.9.2 - PostgreSQL version: 13.7 - pip version: 20.3.4 **Describe the bug** I am...

papel

Made the log method a weakreference

6

This is a fix for [issue 1670](https://github.com/psycopg/psycopg2/issues/1670). The issue outlines a bug where garbage collector cannot destroy the LoggingConnection object since it has a bound method called log on it.

spatankar-dmpna

**Please complete the following information:** - OS: Windows - Psycopg version: 2.8.3 - Python version: 3.6 - PostgreSQL version: 13 - pip version: conda 23.7.4 **Describe the bug** Please let...

spatankar-dmpna

Bumps [peter-evans/repository-dispatch](https://github.com/peter-evans/repository-dispatch) from 2 to 3. Release notes Sourced from peter-evans/repository-dispatch's releases. Repository Dispatch v3.0.0 ⚙️ Updated runtime to Node.js 20 The action now requires a minimum version of v2.308.0...

dependabot[bot]

Bumps [pypa/cibuildwheel](https://github.com/pypa/cibuildwheel) from 2.16.2 to 2.16.5. Release notes Sourced from pypa/cibuildwheel's releases. v2.16.5 🐛 Fix an incompatibility with the GitHub Action and new GitHub Runner images for Windows that bundle...

dependabot[bot]

Bumps [actions/cache](https://github.com/actions/cache) from 3 to 4. Release notes Sourced from actions/cache's releases. v4.0.0 What's Changed Update action to node20 by @​takost in actions/cache#1284 feat: save-always flag by @​to-s in actions/cache#1242...

dependabot[bot]

psycopg2 The error message does not match the actual situation

11

**This is a bug tracker** If you have a question, such has "how do you do X with Python/PostgreSQL/psycopg2" please [write to the mailing list](https://lists.postgresql.org/manage/) or [open a question](https://github.com/psycopg/psycopg2/discussions) instead....

a984120978