[Zope] ZSQL: postgres, SELECT INTO

[Steve Drees]

> 
> 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 )
>