[ADMIN] Index Problem 2

1999-02-10 Thread Yip Yuk Ling
One of the subscriber in this mailing list reply to me that Postgresql is unable to create a index with 8 elements. Then what can i do? Is there any method that can allow me to create a index with 8 elements? or should I need to breakdown the table into two smaller table and create two index for

Re: [ADMIN] Create Index Problem

1999-02-10 Thread Bruce Momjian
> Hi, >I want to create a index with 8 items, but postgresql report an error > message. (arguement 8>7?) > do postgressql can only create a index with max. 7 items? Yes. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]| (610) 853-3000

[ADMIN] Create Index Problem

1999-02-10 Thread Bennett Yip
Hi, I want to create a index with 8 items, but postgresql report an error message. (arguement 8>7?) do postgressql can only create a index with max. 7 items?

[ADMIN] Admin of Postgres connections

1999-02-10 Thread Colin Price (EML)
Running PostgreSQL 6.4 under Linux 2 queries with which I will be very grateful if answered. 1. The temp area I'm previously an Oracle DBA (apologies if I just blasphemed). Oracle allowed a designated area for temporary objects to be created. This was used by, for example, executing SQL s

RE: [ADMIN] having problem with postgresql-6.4.2

1999-02-10 Thread Frans de Wet
You have to either uninstall the old postgres RPM before upgrading or remove all the old postgres executables out of the /usr/bin directory ... they are causing it ... had the same problem just a few days ago ... Frans > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTE

[ADMIN] having problem with postgresql-6.4.2

1999-02-10 Thread hoelc
Hello, I'm trying to install postgresql-6.4.2 on my RedHat Linux 5.0. and got this error massage when creating database installation from postgres superuser(postgres), with command ' $ initdb ' : { this is the end part of the massage, where I notice some error } : ini