Re: Delete with foreign keys

From: felix(at)crowfix(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Delete with foreign keys
Date: 2008-02-23 07:47:04
Message-ID: 20080223074704.GA12653@crowfix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)crowfix(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aarni Ruuhimäki 2008-02-23 21:06:28 Re: SQL standards in Mysql
Previous Message dipesh 2008-02-23 07:12:13 Re: Delete with foreign keys