Delivery-Date: Fri, 06 May 94 00:23:52 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405060457.VAA06080@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Thu, 5 May 94 21:56:51 PDT
From: tjw00@spg.amdahl.com (Tom Wye)
Message-Id: <9405060456.AA00988@petal.spg.amdahl.com>
To: postgres@postgres.Berkeley.EDU
Subject: how to define unique keys
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 05 May 94 21:57:02 -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.
===============================================================================