From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: DELETE ... RETURNING |
Date: | 2009-07-13 22:08:05 |
Message-ID: | h3gb85$7bv$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2009-07-13 22:35:31 | Re: DELETE ... RETURNING |
Previous Message | Oliver Jowett | 2009-07-13 21:57:35 | Re: DELETE ... RETURNING |