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 <archeron@wavefire.com> 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 .
/ \ -----------------------------------------------------------------