Thread

1. Still big problem with 6.4

   Michael Meskes <meskes@online-club.de> — 1998-09-02T05:46:38Z

   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! 
   
   

2. Release 6.4. where is it?

   Ordini <sferac@bo.nettuno.it> — 1998-09-02T13:44:55Z

   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'
   
   
   
   

3. Re: [HACKERS] Release 6.4. where is it?

   David Hartwig <daveh@insightdist.com> — 1998-09-02T16:29:25Z

   
   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.
   
   
   

4. Re: [HACKERS] Release 6.4. where is it?

   Marc Fournier <scrappy@hub.org> — 1998-09-02T16:43:51Z

   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...