[Zope] ZSQL ? PoPy

Mark Twiddy vtwiddy@senet.com.au
Wed, 1 Nov 2000 15:34:17 +1030 (CST)


Hi all

Can someone please tell me what is going on here?

I have an query that selects data into a temp table.
It then deletes some stuff from the temp table
Then is deletes some more stuff 
Then i select the remaining records and drop the table

The problem is that when i try to select the remaining records it just
hangs. I do a ps on this i and i can see the query is running but it just
does not return anything and fills up disk.

I am using PoPy 1.4 Postgres  6.5.1 on i386-unknown-freebsd2.2.7, compiled
by gcc 2.7.2.1]

any clues


Thanks Mark