>
> 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 >
>
> 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:
>
>
>
> ___
> Zope maillist - [EMAIL PROTECTED]
> 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 )
>
___
Zope maillist - [EMAIL PROTECTED]
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 )