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.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@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