From BARRANTE@teleline.es Tue Jun 23 14:15:48 1998 Received: from tsai3.teleline.es (teleline.teleline.es [194.224.53.3]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA22509 for ; Tue, 23 Jun 1998 10:15:48 -0400 (EDT) Received: from default ([195.235.10.185]) by tsai3.teleline.es (Netscape Mail Server v2.02) with SMTP id AAA15132 for ; Tue, 23 Jun 1998 16:27:41 +0200 Message-ID: <001c01bd9eb1$6a136d60$b90aebc3@default> From: "Dionisio Barrantes Blanco" To: "soporte postgres ingles" Subject: foreign keys Date: Tue, 23 Jun 1998 16:15:44 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01BD9EC2.2CC20A00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01BD9EC2.2CC20A00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Somebody can tell me how Postgres solves the referential integrity = problem. I think I can't use 'constraints' for foreign keys. =BFWhat's = the easier way to declare and manage foreign keys? . Thanks Dionisio Barrantes ------=_NextPart_000_0019_01BD9EC2.2CC20A00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Somebody can tell me how Postgres = solves the=20 referential integrity problem. I think I can't use 'constraints'  = for=20 foreign keys. ¿What's the easier way to declare and manage = foreign keys?=20 .
 
Thanks
Dionisio Barrantes
------=_NextPart_000_0019_01BD9EC2.2CC20A00-- From marin@cybernet.bg Wed Jun 24 14:59:06 1998 Received: from server.iclub.techno-link.com (server.cybernet.bg [212.36.3.249]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA16979 for ; Wed, 24 Jun 1998 10:59:06 -0400 (EDT) Received: from localhost (marin@localhost) by server.iclub.techno-link.com (8.8.8/8.?.?) with SMTP id RAA22512; Wed, 24 Jun 1998 17:51:32 +0300 Date: Wed, 24 Jun 1998 17:51:31 +0300 (EET DST) From: Marin D X-Sender: marin@server.iclub.techno-link.com To: Dionisio Barrantes Blanco cc: soporte postgres ingles Subject: Re: [SQL] foreign keys In-Reply-To: <001c01bd9eb1$6a136d60$b90aebc3@default> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Content-Transfer-Encoding: QUOTED-PRINTABLE Take a look at the contrib/spi/refint* under your PostgreSQL source tree... =09Marin -=3D Why do we need gates in a world without fences? =3D- On Tue, 23 Jun 1998, Dionisio Barrantes Blanco wrote: ->Somebody can tell me how Postgres solves the referential integrity proble= m. I think I can't use 'constraints' for foreign keys. =BFWhat's the easie= r way to declare and manage foreign keys? . -> ->Thanks ->Dionisio Barrantes -> From michael.davis@prevuenet.com Thu Feb 25 15:34:46 1999 Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA96038; Thu, 25 Feb 1999 10:34:46 -0500 (EST) (envelope-from michael.davis@prevuenet.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2232.9) id FS6Y3F2C; Thu, 25 Feb 1999 09:33:27 -0600 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id <1X3LWGF8>; Thu, 25 Feb 1999 09:36:26 -0600 Message-ID: <93C04F1F5173D211A27900105AA8FCFC1451F4@lambic.prevuenet.com> From: Michael Davis To: "'pgsql-interfaces@postgreSQL.org'" , pgsql postgres , pgsql-hackers@postgreSQL.org Subject: Foreign Keys Date: Thu, 25 Feb 1999 09:32:20 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain What is the possibility of recording foreign keys (a partial foreign key implementation) in the database such that the ODBC interface can correctly report them to client applications? This would require an enhancement to Postgres and to the ODBC driver for Postgres. I have a problem with Access 97 not working properly with forms that contain sub forms representing parent/child or master/detail tables. For example: orders and orderlines. I think this is caused by the lack of foreign key support. I am basing this conclusion on the SQL statement that Access sent through ODBC when looking up records for the sub form. The where clause of the SQL statement was based on the primary key of the child or detail table. The where clause needs to be based on the column that is linked to the parent or master table. I already have indexes installed on both the primary key and the field that links to the master/parent table. I am willing to explore a work around and/or help with these enhancements. This issue, at least for the moment, appears to be a show stopper for me. Any Suggestions? Thanks, Michael From byronn@insightdist.com Thu Feb 25 16:16:28 1999 Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA01639 for ; Thu, 25 Feb 1999 11:16:28 -0500 (EST) (envelope-from byronn@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id KAA04853 for pgsql-interfaces@postgreSQL.org; Thu, 25 Feb 1999 10:50:12 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA29475; Thu, 25 Feb 1999 10:36:23 -0500 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA61846; Thu, 25 Feb 1999 10:36:22 -0500 Message-Id: <36D56E55.5D42F476@insightdist.com> Date: Thu, 25 Feb 1999 10:37:57 -0500 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Michael Davis Cc: "'pgsql-interfaces@postgreSQL.org'" , pgsql postgres , pgsql-hackers@postgreSQL.org Subject: Re: [INTERFACES] Foreign Keys References: <93C04F1F5173D211A27900105AA8FCFC1451F4@lambic.prevuenet.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Michael Davis wrote: > What is the possibility of recording foreign keys (a partial foreign key > implementation) in the database such that the ODBC interface can correctly > report them to client applications? This would require an enhancement to > Postgres and to the ODBC driver for Postgres. I have a problem with Access > 97 not working properly with forms that contain sub forms representing > parent/child or master/detail tables. For example: orders and orderlines. > I think this is caused by the lack of foreign key support. I am basing this > The driver does support SQLForeignKeys. It does say it supports this function in SQLFunctions. However, the current implementation is based on the SPI/trigger stuff from the pg_trigger table. If you don't have any trigger info, then SQLForeignKeys will not report anything. This is most likely the problem. Byron From michael.davis@prevuenet.com Thu Feb 25 16:48:14 1999 Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA04923; Thu, 25 Feb 1999 11:48:14 -0500 (EST) (envelope-from michael.davis@prevuenet.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2232.9) id FS6Y3GJ7; Thu, 25 Feb 1999 10:46:49 -0600 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id <1X3LWGMB>; Thu, 25 Feb 1999 10:49:47 -0600 Message-ID: <93C04F1F5173D211A27900105AA8FCFC1451F8@lambic.prevuenet.com> From: Michael Davis To: "'pgsql-interfaces@postgreSQL.org'" , pgsql postgres , pgsql-hackers@postgreSQL.org Subject: RE: [INTERFACES] Foreign Keys Date: Thu, 25 Feb 1999 10:45:41 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain Excellent! I will start working on it. -----Original Message----- From: Byron Nikolaidis [SMTP:byronn@insightdist.com] Sent: Thursday, February 25, 1999 8:38 AM To: Michael Davis Cc: 'pgsql-interfaces@postgreSQL.org'; pgsql postgres; pgsql-hackers@postgreSQL.org Subject: Re: [INTERFACES] Foreign Keys Michael Davis wrote: > What is the possibility of recording foreign keys (a partial foreign key > implementation) in the database such that the ODBC interface can correctly > report them to client applications? This would require an enhancement to > Postgres and to the ODBC driver for Postgres. I have a problem with Access > 97 not working properly with forms that contain sub forms representing > parent/child or master/detail tables. For example: orders and orderlines. > I think this is caused by the lack of foreign key support. I am basing this > The driver does support SQLForeignKeys. It does say it supports this function in SQLFunctions. However, the current implementation is based on the SPI/trigger stuff from the pg_trigger table. If you don't have any trigger info, then SQLForeignKeys will not report anything. This is most likely the problem. Byron From echiner@tissat.es Thu Jul 15 17:15:25 1999 Received: from capitular.tissat.es ([195.77.30.35]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA37047 for ; Thu, 15 Jul 1999 13:15:25 -0400 (EDT) (envelope-from echiner@tissat.es) Received: from tissat.es ([195.77.30.15]) by capitular.tissat.es (Netscape Messaging Server 3.5) with ESMTP id AAA6C62 for ; Thu, 15 Jul 1999 19:14:52 +0200 Message-ID: <378E16E1.BE3CFEF9@tissat.es> Date: Thu, 15 Jul 1999 19:14:09 +0200 From: "Esteban Chiner Sanz" X-Mailer: Mozilla 4.5 [es] (WinNT; U) X-Accept-Language: es MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Foreign keys Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I know there are no foreign keys in Postgres but, what could be the best/most efficient way to simulate them? Thank you, Esteban ------------------------------------------------------------ Esteban Chiner Sanz mailto (work): echiner@tissat.es TISSAT mailto (home): echiner@abonados.cplus.es Av. Aragon, 30, 5ª planta Phone: 96 393 9950 Valencia (SPAIN) From djackson@cpsgroup.com Thu Jul 15 17:58:43 1999 Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA43046 for ; Thu, 15 Jul 1999 13:58:43 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id MAA12968; Thu, 15 Jul 1999 12:58:46 -0500 (CDT) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma012956; Thu, 15 Jul 99 12:58:30 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id <3Y5R5GM6>; Thu, 15 Jul 1999 12:58:09 -0500 Message-ID: From: "Jackson, DeJuan" To: Esteban Chiner Sanz , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Foreign keys Date: Thu, 15 Jul 1999 12:58:05 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id NAA43051 Triggers. Check the contrib directory from the distribution for refint. > -----Original Message----- > From: Esteban Chiner Sanz [SMTP:echiner@tissat.es] > Sent: Thursday, July 15, 1999 12:14 PM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] Foreign keys > > I know there are no foreign keys in Postgres but, what could be the > best/most efficient way to simulate them? > Thank you, > > Esteban > > ------------------------------------------------------------ > Esteban Chiner Sanz mailto (work): echiner@tissat.es > TISSAT mailto (home): echiner@abonados.cplus.es > Av. Aragon, 30, 5ª planta Phone: 96 393 9950 > Valencia (SPAIN) > > From Aguinaldo.Fagundes@vantcom.net Thu Mar 30 21:23:02 2000 Received: from paentms1.vantcom.net ([200.225.160.20]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA95021 for ; Thu, 30 Mar 2000 16:23:02 -0500 (EST) (envelope-from Aguinaldo.Fagundes@vantcom.net) Received: by PAENTMS1 with Internet Mail Service (5.5.2650.21) id ; Thu, 30 Mar 2000 18:21:52 -0300 Message-ID: <35DE6A7B82C8D3119B3B00508B8B7A492BB9E0@PAENTMS1> From: Aguinaldo Fagundes Junior To: pgsql-sql@postgresql.org Subject: Foreign keys Date: Thu, 30 Mar 2000 18:21:51 -0300 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Archive-Number: 200003/3 Hi, Can anybody help me with this: -> Which is the best way to implement foreign keys constraints? Thank you! From No Name Tue Feb 6 05:01:14 2001 Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1651Ex12018 for ; Tue, 6 Feb 2001 00:01:14 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f12105q06117 for ; Thu, 1 Feb 2001 20:00:05 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f120ubm36845 for pgsql-sql@postgresql.org; Thu, 1 Feb 2001 19:56:37 -0500 (EST) (envelope-from news) From: "" X-Newsgroups: comp.databases.postgresql.sql Subject: Foreign Keys Date: Thu, 1 Feb 2001 19:59:49 -0500 Organization: Lines: 4 Message-ID: <95d0k4$13v7$3@news.tht.net> X-Complaints-To: scrappy@hub.org X-Newsreader: Microsoft Outlook Express 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 To: pgsql-sql@postgresql.org X-Archive-Number: 200102/68 X-Sequence-Number: 1238 I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to be the problem? From cfaber@fpsn.net Tue Feb 6 05:26:08 2001 Received: from mail.fpsn.net (mail.fpsn.net [63.224.69.57]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f165Q7x16562 for ; Tue, 6 Feb 2001 00:26:08 -0500 (EST) (envelope-from cfaber@fpsn.net) Received: from fpsn.net (control.fpsn.net [63.224.69.60]) by mail.fpsn.net (8.9.3/8.9.3) with ESMTP id WAA46387; Mon, 5 Feb 2001 22:25:55 -0700 (MST) (envelope-from cfaber@fpsn.net) Message-ID: <3A7F8AE1.B06A020C@fpsn.net> Date: Mon, 05 Feb 2001 22:25:53 -0700 From: Colin Faber Reply-To: cfaber@fpsn.net Organization: fpsn.net, Inc. X-Mailer: Mozilla 4.75 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: "" CC: pgsql-sql@postgresql.org Subject: Re: Foreign Keys References: <95d0k4$13v7$3@news.tht.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/70 X-Sequence-Number: 1243 Foreign keys are not supported in that version :p see: http://www.postgresql.org/devel-corner/docs/ "" wrote: > I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to > be the problem?