psycopg/zpsycopgda

psycopg2 Zope adapter

ZPsycopgDA -- psycopg2 Zope adapter

• Project page
• Download
• Psycopg mailing list

This is the PostgreSQL adapter for Zope 2 and 3 based on psycopg2.

As of version 2.4.6, ZPsycopgDA has the same content of the ZPsycopgDA module included in Psycopg 2.4.6. Future psycopg2 versions will likely not include ZPsycopgDA, which should be installed separately.

Prerequisites

ZPsycopgDA depends on the psycopg2 module version at least 2.4. Don't use versions 2.4.2 or 2.4.3: they are not compatible with ZPsycopgDA. Install the latest version available.

Installation

Unfortunately I'm no Zope expert, so these installation instructions are quite approximative. Please contact us if you want to improve them.

• Make sure to have your Zope lib directory in the $PYTHONPATH. If some command fails with:

  [...]
  File "[...]/ZPsycopgDA/db.py", line 18, in <module>
    from Shared.DC.ZRDB.TM import TM
  ImportError: No module named Shared.DC.ZRDB.TM
  

  you are probably missing it.

• Download the ZPsycopgDA package, unpack it and copy the ZPsycopgDA directory into the Products directory of your Zope instance.

• Alternatively run easy_install ZPsycopgDA or pip install ZPsycopgDA, then symlink or copy the ZPsycopgDA directory from the installed location to the Products directory of your Zope instance.

zpsycopgda's Issues

Another way to install your product

Connection pooling leads to confused transaction isolation levels

There is an issue with this DA which leads to several Zope Connection objects to share pooled connections, even when they have different transaction isolation levels.

This leads to unexpected behaviour, because transaction isolation levels change seemingly at random.

A test sequence which performs "select setting from pg_settings where name = 'transaction_isolation'" on different connectors exposes the problem.

I have written a patch which fixes this, and I would be glad to contribute, but this editor does not allow me to attach a patch file...

How can I pass the patch to you?

error while installing psycopg2

I am a beginner and I am facing issue in psycopg2 installation in my pycharm (venv) on my windows. How to solve it...

error

(venv) C:\Users\Vishal\PycharmProjects\website>pip install psycopg2
Collecting psycopg2
Using cached https://files.pythonhosted.org/packages/84/d7/6a93c99b5ba4d4d22daa3928b983cec66df4536ca50b22ce5dcac65e4e71/psycopg2-2.8.4.tar.gz
Complete output from command python setup.py egg_info:
running egg_info
creating pip-egg-info\psycopg2.egg-info
writing pip-egg-info\psycopg2.egg-info\PKG-INFO
writing dependency_links to pip-egg-info\psycopg2.egg-info\dependency_links.txt
writing top-level names to pip-egg-info\psycopg2.egg-info\top_level.txt
writing manifest file 'pip-egg-info\psycopg2.egg-info\SOURCES.txt'

Error: pg_config executable not found.

pg_config is required to build psycopg2 from source. Please add the directory
containing pg_config to the $PATH or specify the full executable path with the
option:

python setup.py build_ext --pg-config /path/to/pg_config build ...

or with the pg_config option in 'setup.cfg'.

If you prefer to avoid building psycopg2 from source, please install the PyPI
'psycopg2-binary' package instead.

For further information please check the 'doc/src/install.rst' file (also at
http://initd.org/psycopg/docs/install.html).

---

Command "python setup.py egg_info" failed with error code 1 in C:\Users\Vishal\AppData\Local\Temp\pip-install-yhws7zqc\psycopg2\

remove namespace_packages=['ZPsycopgDA'], from setup.py

The package isn't a namespace package, and this greatly hinders installation as both pip install ZPsycopgDA as well as easy install ZPsycopgDA both fail.

The offending line: https://github.com/psycopg/ZPsycopgDA/blob/master/setup.py#L48

Release version 2.4.7

Could we have a release 2.4.7, please?
The fix for issue #2 is quite important ...