Return-Path: owner-postman Delivery-Date: Sat, 30 Apr 94 20:13:09 -0700 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA02895 for postgres-redist; Sat, 30 Apr 1994 17:57:11 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199405010057.RAA02895@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from amdahl.com (amdahl.com [129.212.11.3]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA02885 for ; Sat, 30 Apr 1994 17:57:10 -0700 Received: by amdahl.com (/\==/\ Smail #25.33) id ; Sat, 30 Apr 94 17:57 PDT Received: from petal.spg.amdahl.com by spg.amdahl.com (4.1/SMI-4.1) id AA14918; Sat, 30 Apr 94 17:57:05 PDT Received: by petal.spg.amdahl.com (4.1/SMI-4.1) id AA03513; Sat, 30 Apr 94 17:57:05 PDT Date: Sat, 30 Apr 94 17:57:05 PDT From: tjw00@spg.amdahl.com (Tom Wye) Message-Id: <9405010057.AA03513@petal.spg.amdahl.com> To: postgres@postgres.Berkeley.EDU Subject: unique index keys are they supported? Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Sat, 30 Apr 94 17:57:11 -0700 Resent-XMts: smtp I have a question about defining a unique key on a class. It appears that the KEY operand on the create class command is not implemented. Is this true? how does one create a class with a unique index? Basically I want to have a class that has a unique index key that prevents a duplicate index key from being added. Thanks PS: you can email me at tjw00@spg.amdahl.com =============================================================================== To add/remove yourself from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ===============================================================================