Activity (RSS)

I not quite sure what that changes. In both cases you end up with:

return _connect(dsn, connection_factory=connection_factory, async=async)

It would seem that...

I propose the attached patch. Is that ok?

Per my example from 2.4.2, in the past the code did choke on improper arguments. I am all for restoring the previous behavior. When someone explicitly calls for...

Yes, actually it is. I cannot remember exactly in which case the c implementation would have swallowed the keyword arguments, apparently not in all of them. Quo...

I thought I was following, now I am not sure:) Is it considered a bug that the connection_factory argument is wrong and the connection still can be made?

FYI us...

Hi,

it will take me some time to test/fix this because I'll be not at the office till Thursday and I'm very busy at the moment.

Best regards,
Wolfgang

I have some other improvements for zope, see ticket #125. But I will need some help to test with a page calling two ZSQLMethods: I don't know how to set it up.

I've fixed the menu for add/edit pages showing all the available isolation level. Note that the default is "repeatable read" because in postgres 9.1 serializabl...

I've tried installing clang on ubuntu and compiling psycopg and found no problem (I was signaled a warning unrelated to what you have reported here, and I'm wor...

Provide a patch then. You are the clang user.

Submitted by: Bradley Saulteaux

building 'psycopg2._psycopg' extension

clang -march=corei7-avx -O3 -ffast-math -fPIC -Wimplicit -DPSYCOPG_DEFAULT_PYDATETIME=1 -...

We don't support directly pip and have no idea of the manifest, metadata or whatever dependency tracker uses. Feel free to provide a patch to fix your problem.

I have a server where outbound HTTP traffic is intentionally prohibited. When deploying my web app, I'm downloading Python package dependencies on another host ...

Talked with the guy: he was using the cursor for other queries too, clearing the internal state.

It is more likely that you are calling execute on one cursor and iterating on another one.

It could be a bug but without the full script it's difficult to tell. Can you post it instead of just copy and pasting some lines, please?

Submitted by: Pietro Delsante <pietro.delsante at gmail.com>

Hello,

I have a script that uses psycopg2 2.4.5 (OS is Ubuntu 12.04, psycopg2 was installed from Ub...

Oh, I see. In PG the serializable and repeatable read used to be the same, since 9.0 iirc serializable became stronger and the previous semantics is available a...

Sorry for the bad formatting and there was also an error:

At my postgresql database (version 8.2) the mapping is as following:

• 0 results in "SET default_transa...

Regarding the isolation level:

In ZPsycopgDA/dtml/edit.dtml serializable is referenced as value 2 (but it has 4):
<option value="2"

            <dtml-if expr="...

Cool, congratz Daniele ! ;-)

This issue was fixed in my devel. To be released in 2.4.6.

Duplicate of issue #114.

Thank you for the analysis, Wolfgang.

As you describe it, seems that most of the mess happens in ZPsycopgDA/db.py

• inconsistent isolation level
• resetting the cl...

Hm, after some quick investigation I think the problem is located at another place. Your patched block gets never called cause get_transaction_status() returns ...

An optional solution would be to replace entirely PersistentConnectionPool.putconn and not invoke _putconn, but it leads to some code duplication.

For me, any s...

Zope has its own transaction management: like any sensible web framework the transaction is rolled back on errors, and commited just before sending the HTTP res...

Attached proposed patch to fix the issue

I'll try but I have to do it on a test machine because my initial error on the production machine is currently not happening any more and I don't want to destab...

Open ticket #125 to track the issue of the rollback with psycopg 2.4.5. Wolfgang, can you please test the patch attached? Thank you.

Hello Wolfgang,

The change in the pool you mention was probably ticket #62, introduced in psycopg 2.4.3.

As you describe it, that change has totally broken psyc...

Hi,

we've encountered a strange Zope / ZPsycopgDA2 problem in the last days: It happens very rarely (more often if a lot of concurrent users use our Zope applic...

Joshua, no answer? I'm putting the ticket on hold as it works for me and I suspect you just didn't install psycopg correctly. If you can still reproduce the bug...

Discussion has run on the ML: http://archives.postgresql.org/psycopg/2012-09/msg00009.php

1. Add a register_json function to create a json typecaster with provided/sniffed oids and provided loads() function.
2. Use it to initialize JSON/JSON[] typecasters...

Submitted by: vishnu

Please call in 414 2360310

Cool, glad you solved your problem. Next time, for such kind of discussion, try the mailing list, where other people with the relevant knowledge may help you ev...

i have been using linux for 15 years. rpms help make sense of all of the packages and yum, and like, help with all of their dependencies. the whole reason i jum...

If libpq is in a non standard place you will have to figure out how to make _psycopg.so find it: that sounds a LD_LIBRARY_PATH job, i.e. not a pleasant one. Why...

and under /lib there is:

lrwxrwxrwx 1 root root 21 Sep 3 04:35 libgssapi_krb5.so.2 -> libgssapi_krb5.so.2.2
-rwxr-xr-x 1 root root 255968 Jul 31 14:58 libgssapi...

oh and i forgot to add ldd libpq.so, which returns:

linux-gate.so.1 =>  (0x0049a000)
libssl.so.10 => /usr/lib/libssl.so.10 (0x00407000)
libcrypto.so.10 => /usr...

ok, so when i do ldd _psycopg2 under /usr/lib/python2.6/site-packages/psycopg2, i get

linux-gate.so.1 =>  (0x00c8a000)
libpython2.6.so.1.0 => /usr/lib/libpytho...

Google provides several hits for "undefined symbol: GSS_C_NT_HOSTBASED_SERVICE". They seem related to the libpq and gssapi. The answers are usually "don't compi...

i can not import psycopg2 into python 2.6.6 running on centos 6.3 with the upgraded rpms of postgresql 9.1. i downloaded the source for psycopg2 and it compiled...

kthxbye!

Federico, Again, thank you for your notes.

Respectfully, I think I may be actually getting it right... I do wish to link dynamically to libpq

Showing results wi...