Could anyone please tell me what the following mean:

NOTICE:  Index pg_type_typname_index: NUMBER OF INDEX' TUPLES (124) IS NOT THE SAME AS HEAP' (114) 
NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (883) IS NOT THE SAME AS HEAP' (422)

I've never seen them before.

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

Fri, 15 Jun 2001 14:42:57 +0200
Michael Meskes <meskes@postgresql.org>
NOTICE messages
Michael Meskes <meskes@postgresql.org> writes:
> Could anyone please tell me what the following mean:
> NOTICE:  Index pg_type_typname_index: NUMBER OF INDEX' TUPLES (124) IS NOT THE SAME AS HEAP' (114) 
> NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (883) IS NOT THE SAME AS HEAP' (422)

> I've never seen them before.

What PG version?  Do you have any open transactions that might have
created or deleted as-yet-uncommitted tables?

			regards, tom lane

Fri, 15 Jun 2001 10:22:53 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: NOTICE messages 
On Fri, Jun 15, 2001 at 10:22:53AM -0400, Tom Lane wrote:
> What PG version?  Do you have any open transactions that might have
> created or deleted as-yet-uncommitted tables?

I'm not sure since this has not happened on my system. Sorry, I wasn't
precise enough. It happens on the system of a co-worker of mine. It seems to
be related to him having installed phpgroupware which uses postgresql as a
backend. But since phpgroupware does not know about transactions I would
assume he will never have open transactions unless you count the time PG
needs to execute a statement.

Also I assume he's using 7.1. But I will try to get some details.

Michael

-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

Fri, 15 Jun 2001 17:28:54 +0200
Michael Meskes <meskes@postgresql.org>
Re: NOTICE messages