Activity (RSS)

Yup, segfault confirmed: I'll take a look.

With this in a file bug.py:

import sys
import psycopg2
DSN = "host={0} dbname={1} user={2} password={3} port={4} sslmode={5}"
dsn = DSN.format("host", "db", "u...

Hey Daniele,

It appears that we are still seeing the -1 rowcount on COPYs in psycopg 2.5.3 when testing against Redshift 1.0.789. This may well be an issue on R...

Hello Bilal,

yes, it works for me: check the test suite. The changeset is released in psycopg 2.5.3

Note that old postgres versions (before 8.2) don't return ...

Daniele, thanks for checking in the fix. I tried this out on May 27 using the branch you suggested, but I am still getting a rowcount of -1.

In [36]: cursor.row...

No, we cannot.

I find hard to think you have libpq installed but not pg_config.

You can write your own pg_config stub script and fake the questions setup.py mak...

No, we cannot.

I find hard to think you have libpq installed but not pg_config.

You can write your own pg_config stub script and fake the questions setup.py mak...

Submitted by: Alper

Hello,

For local development our django project needs to install psycopg even though we do not use it locally.

This installation depends on ...

More of a wishlist I guess, but the docs state that psycopg2 has "connection" class and "cursor" class. If you believe that:

assert isinstance( conn, psycopg2....

Submitted by: dmaziuk@bmrb.wisc.edu

More of a wishlist I guess, but the docs state that psycopg2 has "connection" class and "cursor" class. If you believe that:

It doesn't seem a good idea to mix up the PyPI metadata and pass psycopg2 2.5.3 when you landed on psycopg 1.1.21.

Just type the name right.

Submitted by: rosuav@gmail.com

I tried to install psycopg with 'pip install psycopg', and it went off looking for version 1, which failed (http://initd.org/pub/...

Christian, extend_path is not designed to fix freeze but for a different use case that doesn't apply to psycopg, so I'm very reluctant to add it. In the past I'...

As far as I can tell, this is exactly as needed. Using debug outputs like

print(__path__)

from pkgutil import extend_path
__path__ = extend_path(__path__, __n...

As far as I can tell, this is exactly as needed. Using debug outputs like

print(__path__)

from pkgutil import extend_path
__path__ = extend_path(__path__, __n...

from extend_path docs:

"This is useful if one wants to distribute different parts of a single logical package as multiple directories"

This doesn't sound what p...

Adding

from pkgutil import extend_path
__path__ = extend_path(__path__, __name__)

to the top of psycopg2/__init__.py resolves the problem and the frozen binar...

You should ask that in the aforementioned ticket, not in a new one.

I don't know what is a persistent db connection. The error message is perfectly compatible with a server that got restarted: in this case django should discard ...

Submitted by: Andrew Poliakov

Python 3.2.3
Django 1.6.5
psycopg2 2.5.3

Django is configured with persistent DB connection. DB connection uses SSL, sslmode=verif...

Submitted by: Christian Bachmaier

I have added a comment with an solution to the (prematurely) closed ticket #201 (http://psycopg.lighthouseapp.com/projects/627...

Adding

from pkgutil import extend_path
__path__ = extend_path(__path__, __name__)

to the top of psycopg2/__init__.py resolves the problem and the frozen binar...

I think the speedup you have in mind is not easy to implement; OTOH it can be generalized. The adaptation codepath is not straightforward as it depends on sever...

Closing as I have no interest in adding feature to a class that has no reason to exist.

As Rui pointed out the number of rows is returned by PQcmdTuples. We weren't calling this function on copy results but only after normal opreations.

Fixed in 2....

On a related note, I have been using psycopg2 with Amazon Redshift and recently asked a similar question about getting the rowcount for COPY statements executed...

Write to the mailing list. You can find info on the website.

You are looking for two-phase commit.

This is not a bug. This is a design or best practices question. If this is off-topic here, please direct me appropriately.

Here is my question: http://stackover...

Provide patches if you want it.

Submitted by: Robert Ziebarth

Wheel (wheel.readthedocs.org/) is a new package format for python packages. It simplifies installation of packages with c extensio...

Bug verified: using an explicit connection.cursor(cursor_factory=None) the default behavior is not triggered (using connection.cursor_factory, then psycopg2.ext...

The error is pretty obvious:

ValueError: Type names and field names can only contain alphanumeric characters and underscores: '?column?'

if you want to use a ...

Greetings. As the title suggested, NamedTupleCursor doesn't work well when passing into connect(). Here's a test case:

import psycopg2
from psycopg2.extras imp...

http://stackoverflow.com/questions/23291907/cursor-factory-none-rai...

It's in program for psycopg3, not before.

Before that you can create your subclass of string, call it Identifier, create an adapter for it and do the double-quo...

I'm currently attempting to create a high-level query builder specific to my application and I need to manually escape literals so they can be added to the quer...

"2.5.2". yes.

Submitted by: Arthur

Hi,

I just want to know if the latest psycopg 9.5.2 is compatible with new postgres version 9.3

Thanks

And please you again use google.

http://stackoverflow.com/questions/6999105/mac-os-x-lion-psycopg2-s...

Hi Daniele,

I've already tried that and that made my install successfully.

However I was asking about the "Import error" not "Install error"

Please read the pos...

Not a bug. Answer here. Please use google.

http://stackoverflow.com/questions/22313407/clang-error-unknown-arg...

Submitted by: Jae Yoo

Hi, here is my error importing the psycopg2 in python 2.7.6 in OSX Maverick

I've tried installing psycoph2 in 2.7.5, and with modifying se...

Makes sense then, thank you!

Yes, it is expected. constraint_name is one of the diag fields that were added to PostgreSQL 9.3.

We experienced this weird behaviour. An IntegrityError was raised (due to a foreign key constraint failing) by psycopg.

Under postgres-9.1 .diag.constraint_name...

Thank you for testing. I don't know what zc.buildout expects but at least we have worked around the setuptools issue.

Fixed the poll() and docs reworded. However poll() doesn't notice immediately either that the connection got closed: it takes another roundtrip. Example:

connec...