Postgres Pro
Downloads
Home   >   mailing lists

Thread: NOTICE messages

NOTICE messages

From
Michael Meskes
Date:
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!

Re: NOTICE messages

From
Tom Lane
Date:
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

Re: NOTICE messages

From
Michael Meskes
Date:
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!