Has anybody selectively used SELECT INTO with zope/postgres?
Make that succesfully.
Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86) Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3] System Platform: linux2 ZPyGreSQLDA-0-0-3
I'm trying something like:
SELECT DISTINCT song, ipadress, date INTO TEMP d_requests FROM requests WHERE date > <dtml-sqlvar startdate type="string"> <dtml-var sql_delimiter> SELECT COUNT(*) AS num_requests, song FROM d_requests GROUP BY song
--------- works fine under psql zope raises an exceptions.ValueError and the db connection dies.
traceback follows: <!-- Traceback (innermost last): File /path/to/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /path/to/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /path/to/zope/lib/python/Zope/__init__.py, line 180, in zpublisher_exception_hook (Object: copy_of_getTopRequests) File /path/to/zope/lib/python/ZODB/Transaction.py, line 180, in begin File /path/to/zope/lib/python/ZODB/Transaction.py, line 155, in abort File /path/to/zope/lib/python/Shared/DC/ZRDB/THUNK.py, line 115, in abort File /path/to/zope/lib/python/Products/ZPyGreSQLDA/db.py, line 117, in _abort ValueError: PQsendQuery() -- There is no connection to the backend.
-->
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )