Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 6A0BC2E00C1
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat, 23 Feb 2008 03:47:18 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 45268-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat, 23 Feb 2008 03:47:12 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from crowfix.com (crowfix.com [216.240.38.154])
	by postgresql.org (Postfix) with ESMTP id 60F272E00E1
	for <pgsql-sql@postgresql.org>; Sat, 23 Feb 2008 03:47:12 -0400 (AST)
Received: (qmail 12678 invoked by uid 1000); 23 Feb 2008 07:47:04 -0000
Date: Fri, 22 Feb 2008 23:47:04 -0800
From: felix@crowfix.com
To: pgsql-sql@postgresql.org
Subject: Re: Delete with foreign keys
Message-ID: <20080223074704.GA12653@crowfix.com>
References: <20080222180021.GA7700@crowfix.com>
	<47BFC74D.9090200@mobilefundas.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <47BFC74D.9090200@mobilefundas.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.347 tagged_above=0 required=5 tests=AWL=0.347
X-Spam-Level: 
X-Archive-Number: 200802/174
X-Sequence-Number: 30265

On Sat, Feb 23, 2008 at 12:42:13PM +0530, dipesh wrote:

>    alter table data add constraint data_place_id_fkey FOREIGN KEY(place_id) 
> REFERENCES place(id) ON DELETE CASCADE ON UPDATE CASCADE;

Interestingly different way of doing it.  Thanks.  It makes me think
too :-)

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o