Re: DELETE ... RETURNING

Oliver Jowett wrote on 13.07.2009 23:57:
> Thomas Kellerer wrote:
>
>> But my understanding is, that it should print "deleted: 3", and then
>> iterate over the returned ids (but at least show the correct update count)
>
> You might want to turn on logLevel=2 and see what the server's actually
> telling us. The update count is usually just derived from the command
> status string, maybe something odd is happening there with DELETE ..
> RETURNING

The log output looks fine as far as I can tell:

00:06:22.037 (1) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)a20892,
maxRows=0, fetchSize=0, flags=1
00:06:22.037 (1) FE=> Bind(stmt=S_1,portal=null)
00:06:22.037 (1) FE=> Execute(portal=null,limit=0)
00:06:22.037 (1) FE=> Parse(stmt=null,query="delete from test_delete returning
id",oids={})
00:06:22.037 (1) FE=> Bind(stmt=null,portal=null)
00:06:22.037 (1) FE=> Describe(portal=null)
00:06:22.037 (1) FE=> Execute(portal=null,limit=0)
00:06:22.037 (1) FE=> Sync
00:06:22.053 (1) <=BE BindComplete [null]
00:06:22.053 (1) <=BE CommandStatus(BEGIN)
00:06:22.053 (1) <=BE ParseComplete [null]
00:06:22.053 (1) <=BE BindComplete [null]
00:06:22.053 (1) <=BE RowDescription(1)
00:06:22.053 (1) <=BE DataRow
00:06:22.053 (1) <=BE DataRow
00:06:22.053 (1) <=BE DataRow
00:06:22.053 (1) <=BE CommandStatus(DELETE 3)
00:06:22.069 (1) <=BE ReadyForQuery(T)

And it still doesn't explain why getMoreResults() is not working either.

Regards
Thomas