Hello Tom, In trying to come up with a test scenario, I loaded this db into a 7.4 db and got a similar message. It shows up as follows:
dropsites=> begin; BEGIN dropsites=> delete from te_users where reseller = 21; ERROR: attempted to mark4update invisible tuple CONTEXT: PL/pgSQL function "c_delete_categories" line 14 at SQL statement dropsites=> Is this the same message using the new error reporting framework? -Wade On September 23, 2003 09:44 pm, Tom Lane wrote: > Wade Klaver <[EMAIL PROTECTED]> writes: > > Stumbled across an odd problem while cleaning data out of a database. I > > am getting these "invalid tid" errors. I tried the upgrade from 7.3.2 to > > 7.3.4. > > Hm. We fixed something with a similar symptom as of 7.3.3: > http://archives.postgresql.org/pgsql-hackers/2003-03/msg01099.php > If you are still seeing it in 7.3.4 then maybe there's another related > problem. Could you work up a self-contained test case? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Wade Klaver Wavefire Technologies Corporation GPG Public Key at http://archeron.wavefire.com /"\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ ----------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]