When running my perftest example I still create an unaccessible index:
postgres@feivel:~/pgsql/src/interfaces/ecpg.mm/test$ ./perftest
I needed 14 seconds and 761468 microseconds for the insert test.
NOTICE: CAN't OPEN INDEX 18378 - SKIP IT
I needed 28 seconds and 444260 microseconds for the selection&projection test.
NOTICE: CAN't OPEN INDEX 18378 - SKIP IT
I needed 72 seconds and 446534 microseconds for the join test.
NOTICE: CAN't OPEN INDEX 18378 - SKIP IT
I needed 0 seconds and 723106 microseconds for the update test.
NOTICE: CAN't OPEN INDEX 18378 - SKIP IT
I needed 0 seconds and 104815 microseconds for the delete test.
NOTICE: CAN't OPEN INDEX 18378 - SKIP IT
sql error Error: ERROR: index "number1" nonexistent
line 118.
NOTICE: (transaction aborted): all queries ignored until end of transaction
block
postgres@feivel:~/pgsql/src/interfaces/ecpg.mm/test$ psql mm
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: mm
mm=> \z
Database = mm
+------------------+----------------------------------------------------+
| Relation | Grant/Revoke Permissions |
+------------------+----------------------------------------------------+
| number1 | |
| number2 | |
| perftest1 | |
| perftest2 | |
+------------------+----------------------------------------------------+
mm=>drop table perftest1;
DROP
mm=> drop table perftest2;
DROP
mm=> \z
Database = mm
+------------------+----------------------------------------------------+
| Relation | Grant/Revoke Permissions |
+------------------+----------------------------------------------------+
| number1 | |
+------------------+----------------------------------------------------+
mm=> drop table number1;
ERROR: Relation number1 Does Not Exist!
mm=> drop index number1;
ERROR: index "number1" nonexistent
As an explanation: number1 is a unique index created on perftest1. The only
way to get rid of it seems to be initdb.
Michael
--
Michael Meskes meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!
