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

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!