Activity (RSS)

Lighthouse has been useful but the experience has not been without problems:

1. service problems
   
2. weird model (no mark as duplicate, just for one that would have b...

More details: this appears to be an issue with the base error class, psycopg2.Error. I hit a segfault when trying to pickle any of the exceptions inheriting fro...

When attempting to pickle an OperationalError, I get an immediate segfault. I understand that OperationalError might not be pickle-able, but I would expect a se...

You'll have to talk to the Lighthouse guys. This ticket has been open as 169, and the 168 was open yesterday, thus they are losing your ticket somewhere.

Submitted by: Chris Schmich

I've created an account and I'm trying to submit an issue through the Lighthouse website, but the ticket is not appearing anywhere.

...

I don't know about %, but ( and ) don't work in Python either. % works in Python but not in psycopg: I'll have to check why.

I think the only fix you may end up...

Closing the bug as duplicate of #144 (I'll have to mark it invalid, but it's perfectly valid: lighthouse limitation).

Submitted by: Thomas Güttler

If you want to host psycopg2 on an own pypiserver pg_config is required. This is strange, since the pypiserver does not run postgre...

Submitted by: Basil Peace grv87@yandex.ru

Documentations says that 'in order to include a literal % in the query you can use the %% string'. However, this doesn...

Sorry, the above comment should be in regard to issue #2

This is great, we just needed to patch it to cast values to string before doing the getquoted call on the array items:

values = [str(v) for v in self.wrapped.v...

Yes, this has been fixed in 2.5.1.

https://github.com/psycopg/psycopg2/commit/889b1d826e9cf0ecbc9af938...

http://initd.org/psycopg/articles/2013/06/23/psycopg-251-released/ says this is fixed — isn't it?

Report details at
http://www.postgresql.org/message-id/CAMmSGrWWNVb=ohTRWXV+Pt5CEGyK8...

No answer back. I'd file it under versions mess up.

I've added some docs to explain how to map date.max to infinity

• http://initd.org/psycopg/docs/extras.html#psycopg2.extras.DateRange
• http://initd.org/psycopg/d...

To be released in 2.5.1

Can't confirm the issue: I've tried creating an user with password @#!* and @#'"!* and found no problem connecting with either methods.

cnn = psycopg2.connect(...

Please specify better: are you creating the connection using a connection string:

cnn = psycopg2.connect("dbname=foo password=abc")

or using separate argument...

Submitted by: olivier.margarit@cgi.com

Hi,
I'm developing a webapp which connect to a postgresql db whith your framework.
One the password I use contains !, *, ...

See https://github.com/psycopg/psycopg2/pull/5

Python dates don't support infinity, so the value is mapped on maxdate, and of course the mapping is not bidirectional. It's a known shortcoming of the dates ma...

Submitted by: David Turon

Hi,
if I get from database range for example:
["2013-05-23 14:31:52.892896+02",infinity)

and then insert back to db
["2013-05-23 14:31...

User not bothering running 2to3.

Submitted by: michael poeltl michael.poeltl@univie.ac.at

psycopg2 (2.5) with python3.3;
extensions.py line 173
for k, v in encodings.items():
k = k.replace('_',...

Michael,

psycopg works perfectly fine on Py3, and it would have been great if it was only a matter of changing basestring into str.

Use "easy_install3 psycopg2"...

Submitted by: michael poeltl michael.poeltl@univie.ac.at

dear all,

in _range.py is basestring in use

?> grep -r basestring ./* ./lib/_range.py: if isinstance(pg...

Joshua can't be bothered. Never do us. The bug is probably caused by incorrect python3 installation as there's plenty of register_composite tests in the test su...

This must have gone with the last solaris patches in master.

Psycopg doesn't support unloading: it has never been tested for this usage. I'm not closing the issue as WONTFIX straight ahead but I won't be working on it. If...

Submitted by: alexsobral@gmail.com

I'm developing a program with embedded Pythhon 3.3.
When I'm using the psysopg2 library I'm having a big memory link only by ...

Yes, I think you won't need anything special from psycopg. If you did, feel free to reopen the ticket.

I did not realize that ltrees are treated as strings so easily. My end-goal was to implement an LTree object for Django, and I thought that Psycopg would need t...

I heavily use ltrees with psycopg (they are just amazing). I use them just as strings. What do you need to implement? They are read-written ok as string, and be...

I have been using psycopg for awhile now, and it's great. I was wondering if support could be added for Postgresql's LTree data type, which can be used to store...

We need more comment about that: what python version is it? What platform?

Can you compile psycopg in debug mode and post the output of the import to see where...

Submitted by: Shyam

import psycopg2 Traceback (most recent call last):
File "", line 1, in File "/x/xxxx/xxxxx/Sxxxxx/python/lib/python2.6/site-packages/psyc...

I think this commit fixes the issue.

https://github.com/dvarrazzo/psycopg/commit/d159dfea9d1e7dd9ebc52c4...

Patch committed to avoid defining round() for solaris 10 and following

https://github.com/dvarrazzo/psycopg/commit/d159dfea9d1e7dd9ebc52c4...

Closing for lack of further information and tests.

Thank you very much: reopening the issue. Will take a look at your patch and integrate it.

Hi Daniele,

I think I'm understanding form Floris' response that round is on all Solaris' version from 8 up.

The issue described here has caused us all sorts of...

Hi Daniele,

Thank-you for the speedy investigation and for the clarification on behavior. In the future I will vet any "issues" through the mailing list prior t...

Don't know what pip freeze is or does.

Submitted by: Kurdy

I just installed 2.5. Pip freeze still shows 2.4.6.
print(psycopg2.__version__) shows 2.5.

Didn't know where to report this.

psycopg 2.4.6 issues SHOW default_transaction_isolation only when asked for conn.isolation_level. If the property is not read the query is not performed.

$ PSY...

Submitted by: Nathen Hinson

All,

Although in a discussion of the changes in psycopg 2.4.6 mentions that the default behavior of the adapter will no longer issue...

Closing as not related to psycopg until further proof.