Activity (RSS)

"I cannot see it, I mean I can understand what has changes"

I can't understand, sorry for the mistake.

Thank you for the fix. I cannot see it, I mean I can understand what has changes. Also github seems to be at 2.4.1 version, and not 2.4.2... I'm not very good w...

yuri,

could you test the behaviour with the current head version (e.g. you may check it out from the devel branch in https://github.com/dvarrazzo/psycopg/).

The...

install a fresh zope
create an adapter instance
go in "test"
write a wrong query

Then, you cannot submit other queries bacause of "current transaction is aborte...

"create" isn't used at all in that method. What do you mean by "impossible to roll back with Zope". Can you make an example?

def getconn(self, create=True):

    conn = pool.getconn(self.dsn)
    if create == False:
     return conn
    conn.set_isolation_level(int(self.tilevel))
    ...

Submitted by: yurj@alfa.it

def getconn(self, create=True):

    conn = pool.getconn(self.dsn)
    conn.set_isolation_level(int(self.tilevel))
    conn.set_clien...

Committed.

I'd vote for moving the Decimal adapter registration to Python.
Nobody uses the C module alone anyway.

I've tested with my collection of dbs and you need at least PostgreSQL 8.4.

Ok, I will ask the admin to upgrade it
Thanks very much!

Your problem is in postgres: probably 8.1 doesn't support NaN in numeric array. Your test works fine with postgres 9.0.

Hi,

Sorry for the lack of info. I post now the definition of the table. I have asked the admin to update the psycopg2 to the last one (2.4.2) but I still get th...

About the other types: I think no: Decimal is the only pure python module imported and used by psycopg in the C layer, all the other builtins are python C types...

Don't know about the other adapter, how do they do adaptation and all. Probably they have always done everything in Python and so ditched the problem.

After a quick review, the psyco_GetDecimalType is still required for the other half of the story: in order to return from Postgres to Python a Decimal type whos...

Cool. Are there any other built-in adapters we have to worry about?

Have you checked what PyGreSQL and MySQLdb are doing to solve this problem?

I've taken a look at the issue. Thank you for the test case: it worked fine and allowed me to debug a little bit.

About the above approach of testing using ctyp...

Cannot reproduce the issue: adaptation seems performed ok. What is the definition of the table?

With the lack of such definition I can only try a cast, and it s...

Submitted by: oscar martinez

Hi, I detected that when having a 3D array of double precesion and some of the values are nan it crashes.

I paste the test I did (I...

I am planning to work at it, but don't have anything in the calendar. 2.4.3 is already to be released, waiting for fog, but I don't mind including a fix for it ...

Are you working on a fix for this, or should I give it a shot myself?

Unfortunately, I think we'll have to live with subinterpreters. Changing the default WSGIA...

It is already fixed, to be released in 2.4.3.

See this commit.

Thank you for the report.

I thought the apache guy had learned to not mess up with sub-interpreter. They are a bloody implementation detail, crap. Isn't there any deploy method not invol...

I have traced down the cause and attached a reproducible test case. Please re-open this bug.

A few weeks ago I was re-reading the mod_wsgi documentation and not...

with rel-2.4.2 I get the following error when running the attached testcase:

$ nosetests tests/raw_psycopg2.py 
F
=============================================...

Added hstore/composite (and generic) array support to my devel branch.

To be released in 2.4.3.

What psycopg version are you using?

The current head works fine: the problem has been most likely fixed in Psycopg 2.3 one year ago.

It would be a nice feature if the copy_from() method supported unicode strings. For example:

import psycopg2

conn = psycopg2.connect("host=192.168.0.33 user=c...

Fixed in my devel. To be released in 2.4.3.

Fixed in my devel. To be released in 2.4.3.

Brilliant, thanks for testing.

I've open ticket #16778 on Django: https://code.djangoproject.com/ticket/16778

Closing this bug as psycopg is doing ok here. Bye!

I can confirm this patach to be working.

Thanks, that was quick. I'll test it right now.

(please see for update to the above comment: I've submitted it before finishing)

Try with this patch. Please try with postgres servers using both parameters for standard_conforming_strings. If we are happy with it we can pass it to the djang...

Does it mean the sum of the length of the column names is more than 8k chars? How long is that?

Probably the author thought it would have been a safe limit... W...

The difference in the output of PQescapeByteaConn is due to the standard_conforming_string setting: it is on by default in PG 9.1.

The difference is taken into ...

Can you provide us with a minimalist python program that expose the problem?

Submitted by: Jonathan Slenders

Still not entirely sure whether this is a bug in psycopg2, but I think it may be.

I have a Django project, with PostGIS setup, a...

Hi JBQ,

Psycopg 2.4.2 has the new set_session() method that allows you to have read only transactions. Internally it uses set default_*. See http://initd.org/p...

Daniele, using "set default" for readonly is a good idea. But if I make the parallel with transaction modes, I can't use "set default_transaction_isolation to S...

Hi All,

I am using psycopg2 happyly to import data from csv files from other databases into a postgres database for analysis. Today I ran into a ValueError rais...

Submitted by: justin.vanwinkle@gmail.com

IndexError Traceback (most recent call last)
/home/jvanwink/repos/milosolr/loader/<ipython-input-83-e90934fd1f1e> in ()...

Array of hstores are not supported yet. Shouldn't be terribly hard to introduce them though.

Do you want to give it a try? Otherwise I could try to make it, but...

db=> create type comp_type_test as (id uuid, f1 char(2), f2 smallint, f3 char(3), f4 char(3));

>>> psycopg2.extras.register_composite('comp_type_test', connec...

The pool now is able to watch for the connection returned, caring to rolling back an eventual open connection or to dispose broken ones.