Received: from mailgw.cc.uga.edu (mailgw.cc.uga.edu [128.192.1.101]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA66598 for ; Wed, 19 Jan 2000 14:13:25 -0500 (EST) (envelope-from spratlen@arches.uga.edu) Received: from archa9.cc.uga.edu (arch9.cc.uga.edu) by mailgw.cc.uga.edu (LSMTP for Windows NT v1.1b) with SMTP id <0.017B570E@mailgw.cc.uga.edu>; Wed, 19 Jan 2000 14:11:35 -0500 Received: from arches.uga.edu (ci191169-a.athen1.ga.home.com [24.4.222.45]) by archa9.cc.uga.edu (8.9.1/8.9.1) with ESMTP id OAA31562 for ; Wed, 19 Jan 2000 14:13:21 -0500 Sender: dan@arches.uga.edu Message-ID: <38860D8E.B3296016@arches.uga.edu> Date: Wed, 19 Jan 2000 14:16:30 -0500 From: Daniel Spratlen X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.14 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Foreign Keys, Triggers and such Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am a MIS student at the University of Georgia. I am doing a project for my Systems Analysis and Design class, and I am using PostgreSQL for the Database. I have taken a data management class and we always used foreign keys. I used a win32 program written by Power Soft called Data Architect. I used the PostgreSQL odbc drivers to interface with the linux box with the database on it. The reason I am writing all this, is that it created all the tables, indexes, and sequences just fine, but it skipped over the foreign keys. I understand that a trigger can be used instead of a foreign key, and I have read an explanation for this reason at http://www.mysql.org/Manual_chapter/manual_Compatibility.html#Missing_Foreign_Keys I was wondering if this is the same reason that PostgreSQL doesn't use foreign keys, and I was wondering exactly how to use the triggers instead of the foreign keys. Sorry for a long story in my message. Thanks in advance for the help. Daniel Spratlen spratlen@arches.uga.edu