Neil Conway <[EMAIL PROTECTED]> writes: > On 21-Mar-04, at 11:39 AM, Kris Jurka wrote: >> Would it be possible to have the command completion tag for EXECUTE >> return >> the affected row count?
> Yes, this has been suggested before -- for example: > http://www.mail-archive.com/[EMAIL PROTECTED]/msg26787.html > I agree it would be a good idea, although I can't recall what the > conclusion of the previous discussions was -- did anyone raise any > critical objections to this? The previous discussion concluded that EXECUTE should return the command tag of the executed command --- eg, "UPDATE n" not "EXECUTE n". Without this, you cannot for example sensibly cope with both the INSERT and UPDATE tag formats. Not sure what it takes internally to the backend to make this happen ... but IIRC there already is provision for utility commands to override their default tag, so I hope that it would be a pretty localized change. However, does this really solve Kris' problem? JDBC generally likes to think that it works with old Postgres versions; will a fix that only works in >= 7.5 be good enough for them? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
