Received: from pcr.ca (www.pcr.ca [207.139.158.13] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id PAA06844 for ; Wed, 19 Jan 2000 15:41:47 -0500 (EST) (envelope-from admin@wtbwts.com) Received: by pcr.ca (Postfix, from userid 1000) id 68A5E1FEE; Wed, 19 Jan 2000 15:40:45 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by pcr.ca (Postfix) with ESMTP id 49BD81FEC; Wed, 19 Jan 2000 15:40:45 +0000 (GMT) Date: Wed, 19 Jan 2000 15:40:45 +0000 (GMT) From: Marc Tardif X-Sender: admin@server.b0x.com To: Daniel Spratlen Cc: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] Foreign Keys, Triggers and such In-Reply-To: <38860D8E.B3296016@arches.uga.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII There is the source code and explanation in the postgresql tarball: contrib/spi/refint.* I think referential integrity will be implemented soon as part of the distribution. It is still at a project level, but you can read about it here: http://www.postgresql.org/projects/devel-refint.html On Wed, 19 Jan 2000, Daniel Spratlen wrote: > 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 > > > ************ > >