Обсуждение: Still big problem with 6.4

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!

Hi all,

Today is Tuesday September, 2 and I can't find postgresql-6.4 on postgresql.org/pub.
There is only postgresql.snapshot.tar.gz. Should I download this one
or there's some delay for v6.4 ?

Thanks
Jose'

On Wed, 2 Sep 1998, Sferacarta Software wrote:

> Hi all,
>
> Today is Tuesday September, 2 and I can't find postgresql-6.4 on postgresql.org/pub.
> There is only postgresql.snapshot.tar.gz. Should I download this one
> or there's some delay for v6.4 ?

v6.4 isn't to be released until Oct 1st...we just went into beta now, with
the snapshot being the current one...

Sferacarta Software wrote:

> Hi all,
>
> Today is Tuesday September, 2 and I can't find postgresql-6.4 on postgresql.org/pub.
> There is only postgresql.snapshot.tar.gz. Should I download this one
> or there's some delay for v6.4 ?

The snapshot is latest 6.4.   Not yet released or stable.   I would not recomend using
this version unless you plan to assist in the debugging effort.

Oct 1 is the scheduled release date.