View Single Post

   
  #2 (permalink)  
Old 04-19-2008, 07:01 PM
felix@crowfix.com
 
Posts: n/a
Default Re: Delete with foreign keys

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote