> What I think should happen is that the command tag should vary according to > whether an INSERT or an UPDATE was performed, so we get a visible > difference without any new tags.
The problem with doing that is that the same command might have updated some tuples and inserted others. Also, we build the tag before the command is executed.
Hmm, I assumed the various anomalies meant that it was a single row only command...
Anybody know where the various anomalies are documented? e.g. how if an insert has been committed that we can't yet see whether we are allowed to update that using same rules as update.
--
Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services