Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UXFFN-0006l5-KU for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2013 18:25:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UXFFN-0006bp-08 for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2013 18:25:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UXFFM-0006bj-3f for pgsql-sql@postgresql.org; Tue, 30 Apr 2013 18:25:48 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UXFFH-0004Vd-NQ for pgsql-sql@postgresql.org; Tue, 30 Apr 2013 18:25:47 +0000 Received: from mailout-de.gmx.net ([10.1.76.27]) by mrigmx.server.lan (mrigmx002) with ESMTP (Nemesis) id 0M06kM-1UJ8fr0Tca-00uKGw for ; Tue, 30 Apr 2013 20:25:43 +0200 Received: (qmail invoked by alias); 30 Apr 2013 18:25:42 -0000 Received: from p5082D1AD.dip0.t-ipconnect.de (EHLO GK1C06) [80.130.209.173] by mail.gmx.net (mp027) with SMTP; 30 Apr 2013 20:25:42 +0200 X-Authenticated: #41312857 X-Provags-ID: V01U2FsdGVkX1/lJEhcPQHlfG5GSgA+ehzddsZQ1fmrGhv31oyjKQ QtgF17NVn+Hq4/ Date: Tue, 30 Apr 2013 20:25:42 +0200 From: Wolfgang Keller To: pgsql-sql@postgresql.org Subject: Re: Correct implementation of 1:n relationship with n>0? Message-Id: <20130430202542.a68c8042be92943866afa16c@gmx.net> In-Reply-To: <3724312.iEkiItIUeG@smadev.internal.net> References: <20130430163905.77d43412c0176c3d9ebd8d90@gmx.net> <3724312.iEkiItIUeG@smadev.internal.net> X-Mailer: Sylpheed 3.3.0 (GTK+ 2.10.14; i686-pc-mingw32) Mail-Copies-To: never Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -4.4 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org > (there is nothing wrong in getting your hands dirty with pl/pgsql btw) The point is that I would have expected that problem to be solved within the past four decades since relational databases have been invented. Or at least in the past two decades since PostgreSQL has been developed. >;-> After all, this should be really an ultra-classic-standard FAQ item. I'm definitely not the first database user in the world who needs to have a 1:n relationship with n>0 and integrity enforced by the database. Sincerely, Wolfgang -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql