Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA25389 for postgres-redist; Mon, 22 Aug 1994 07:18:25 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199408221418.HAA25389@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from freinet.de (bock.freinet.de [193.141.226.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA25379 for ; Mon, 22 Aug 1994 07:18:22 -0700 Received: from tjb.freinet.de by freinet.de (NX5.67d/Freinet 1994-07-06 FW) id AA01803; Mon, 22 Aug 94 15:19:12 +0100 Message-Id: From: tbalzer@tjb.freinet.de (Thomas Balzer) Subject: not null, unique and foreign keys To: postgres@postgres.Berkeley.EDU Date: Sun, 21 Aug 1994 18:57:56 +0200 (MET DST) X-Mailer: ELM [version 2.4 PL23] Content-Type: text Content-Length: 431 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Mon, 22 Aug 94 07:18:25 -0700 Resent-XMts: smtp Hello everybody, is there a way to tell Postgres that an attribute in a class is unique or not null? How to define a foreign key? I can't find anything in the documentation of Postgres 4.2. I think they used foreign keys for the system tables, aren't they? Thanks, --- Thomas | Thomas Balzer | Hans-Thoma-Strasse 17 | D-79664 Wehr | | Germany | Internet: tbalzer@tjb.freinet.de | Phone: +49-7762-1412 | ============================================================================== To add/remove yourself to/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. ==============================================================================