Skip site navigation (1) Skip section navigation (2)

Strange NOTICE

From: Michael Meskes <meskes(at)online-club(dot)de>
To: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Strange NOTICE
Date: 1998-08-31 07:20:59
Message-ID: 19980831092059.A3886@online-club.de (view raw or flat)
Thread:
Lists: pgsql-hackers
I'm just trying the three ecpg examples. Perftest gives me a stange NOTICE
line on every statement:

NOTICE: CAN't OPEN INDEX 18346 - SKIP IT

I tried again after running initdb, but still get this notice, just with a
different number: 18314.

Also the last step gives an error:

sql error Error: ERROR: index "number1" nonexistent
 line 118.
NOTICE: (transaction aborted): all queries ignored until end of transaction
block

This happens when trying to drop index number1. Trying to drop it manually
from psql I get: ERROR: index "number1" nonexistent

Eventually this leaves me with a DB that seems to have a relation number1
(which also exists in the filesystem) but is not accessible at all from
psql.

Michael
-- 
Michael Meskes			meskes(at)online-club(dot)de, meskes(at)debian(dot)org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-08-31 07:51:27
Subject: Re: [HACKERS] odd pg_dump output?
Previous:From: Sbragion DenisDate: 1998-08-31 06:53:12
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group