Activity (RSS)

File exist "pyerrors.h":
avelino@avelino ~/projects/y/jpfm/src (master) $ ll /usr/local/Cellar/python/2.7.5/Frameworks/Python.framework/Versions/2.7/include/pyt...

PyBaseExceptionObject is included in pyerrors.h. If you can't find this file in /usr/local/Cellar/python/2.7.5/Frameworks/Python.framework/Versions/2.7/include/...

Submitted by: Thiago Avelino thiago@avelino.xxx

/usr/local/bin/pip run on Tue Oct 15 23:19:25 2013 Downloading/unpacking psycopg2

Getting page https://pypi.pyt...

Psycopg doesn't parse the connection string: it is passed verbatim to the libpq.

In [3]: psycopg2.connect("postgresql://postgres@localhost:5432/test")
Out[3]: ...

Sounds sensible. Thanks Daniele! :-)

Hello Chad,

the use case for such subclass is fairly restricted, and I think it would be more the hassle to document it than its general usefulness, not to ment...

Submitted by: Joe F

According to the documentation for connect:

The connection parameters can be
specified as a libpq connection string using the dsn parameter

...

Most definitely it is some library mix-up on your box.

Looks like this is a duplicate of http://psycopg.lighthouseapp.com/projects/62710/tickets/111-library...

I'm having an issue with psycopg2. This issue never presented under 2.4.5 until I tried to install 2.5. After noticing the issue I uninstalled (pip) and re-inst...

Thanks @dvarrazzo. Scoping our register_composite calls to the connection or cursor would narrow the race condition, but wouldn't eliminate it. I'm not sure we ...

Caching of the attribute is necessary but it's local to the scope you have registered the composite.

Avoid using register_composite with global=True: use it on ...

Submitted by: Chad Whitacre (whit537)

psycopg2 caches the attributes of composite types, so that when the type is altered in the database, the next attempt to c...

I can confirm that with your code from the master branch of https://github.com/dvarrazzo/psycopg, the segfault goes away. Thanks!

It's in the exception pickling: I think it's caused by bug #170

Core was generated by `python gwebapp.py'.
Program terminated with signal 11, Segmentation faul...

I have an application using gevent 0.13.8 + psycopg2 2.5.1 which segfaults when an attempt is made to 'green' psycopg using a slight variant of Daniele Varrazzo...

I have an application using gevent 0.13.8 + psycopg2 2.5.1 which segfaults when an attempt is made to 'green' psycopg using a slight variant of Daniele Varrazzo...

An array of INET is returned as an unparsed string while and array of TEXT is parsed correctly and returned as a list of strings.
I tested on 2.5.1 and 2.4.6 an...

An array of INET is returned as an unparsed string while and array of TEXT is parsed correctly and returned as a list of strings.
I tested on 2.5.1 and 2.4.6 an...

If I remember correctly the libpq docs don't say if it is possible to
retrieve the number of inserted columns and we're not sending data
line-by-line but as chu...

As asked by Ryan Kelly on the ML:

I'm wondering if it's possible to get the number of rows copied when
using copy_from? I would've thought the .rowcount attribu...

Daniele, wait. He was talking about a simple benchmark and I can see where the bottleneck is. The mogrification of arrays is slow, because the arguments are che...

Thank you for inventing the SQL injection.

Of course feel free to do it in your app if you know where the input is coming from, but don't even think to suggest ...

After a chat on the ML, the idea is to leave the json adapter as it is.

Easy workarounds are to cast json to text and to register the text/unicode adapter on th...

Submitted by: ChrisB

If I run cursor.mogrify on a 64000 double array it is taking 350ms. If I just do a 'ARRAY[' + ','.join(map(str, array)) + ']' and put it in...

I've written to pgsql-general to get some explanation. Here's an answer: http://www.postgresql.org/message-id/52136DB9.3040700@gmail.com

So it's documented that...

On Wed, Aug 21, 2013 at 11:48 PM, Lighthouse <no-reply@lighthouseapp.com> wrote:
> So i currently have PostgreSQL up and running! Very cool! It only took me abo...

Hello Gents.

I posted the following reply yesterday as an attachment, and I thought it was sent, but I guess it didn't. So here it is in its entirety:

Gentleme...

Hi Niel,

The 32bit install does work on a 64bit OS, so the (good?) news is that is not the issue.

Since the installer initially finds the Python 3.3 directory, ...

Hello Niel,

I've forwarded a message to Jason, who is the kind person providing the Windows builds. He may be able to point you in the right direction.

For what...

Hello, good folks at psycopg.

Just tried installing psycopg2 for Windows with the installers located at:

http://www.stickpeople.com/projects/python/win-psycopg/

Looking back the specs, they say:

An IndexError should be raised in case a scroll operation would leave
the result set.  In this case, the cursor position is l...

You are right: scrolling out-of-bound should raise an exception as per DBAPI.

Detecting an out-of-bound movement seems easy enough looking at the status (MOVE n...

The current behaviour descends from the way psycopg casts datetime objects and how postgresql reacts to that.

Psycopg commands result in:

SET TIMEZONE = 'Ameri...

This looks an internal greenplum error, it's not a psycopg one.

It's a sort of reasonable expectation, yes. If you provide the implementation for it we would merge it to devel. The best way to contribute is to open a feature...

I think RowDict should behave like an OrderedDict. In particular, I would expect the following to be True:

[row_dict[k] for k in row_dict.keys()] == list(row_d...

Upon inserting a non-naïve datetime.datetime object, i.e. one with a time zone, psycopg2 converts the timestamp before inserting it, even if the time zone of th...

Submitted by: Saravanakumar Karunanithi

psycopg2.InternalError: bfz_nothing_write_ex write failed with (errno 28) No space left on device (compress_nothing.c:48...

Hello I tried using psycopg's server side cursor scroll() function
When I scroll it with a out of bound value, it does not raise an Exception as the psycopg2 do...

See http://www.postgresql.org/message-id/CAKwjivd9xb=oYc6zAk1HtHA0UguEj...

I've written to the mailing list my ideas about the issue. Feel free to take part to the discussion.

The automatic cast of json was introduced in a major releas...

Mmm, i think you are right, the choice of adapting automatically json is questionable.

Eric, while we decide how to fix the problem you can disable the automati...

I have to agree. IMHO, the json adapter should exist but its registration should not be automatic.

Submitted by: eric casteleijn

Recent versions of Postgres allow returning json from queries. Psycop since version 2.5.0 decided to call json.loads on the query ...

Issue fixed in my branch: https://github.com/dvarrazzo/psycopg/commit/0e08fbb20b9f5bf004d8ab7...

To be released in 2.5.2.

Chris, I'm not working on this, I don't think I'll do anything about it in these days.

If you want to try working at it I'd be very grateful.

It would be great ...

Hi Daniele,

Thanks for the quick response, and sorry for being so delayed in mine.

Your explanation makes sense, and it's consistent with what I'm seeing.

I'd b...

We can transfer the bugs from Lighthouse to GitHub and just forget about the numbers. If possible we could add a final comment to every lighthouse bug with a li...

Chris,

thank you for your report. Yes, bug confirmed. The problem is probably with exceptions containing no result (e.g. generated on connect), because for the ...