Postgres Pro
Downloads
Home   >   mailing lists

Re: Delete with join -- deleting related table entries? - Mailing list pgsql-sql

From BigSmoke
Subject Re: Delete with join -- deleting related table entries?
Date
Msg-id 1139419559.188208.72500@g43g2000cwa.googlegroups.com
Whole thread Raw
In response to Delete with join -- deleting related table entries?  (Bryce Nesbitt <bryce1@obviously.com>)
Responses Re: Delete with join -- deleting related table entries?  (Bryce Nesbitt <bryce1@obviously.com>)
List pgsql-sql
Tree view 
I'm not sure if this is true for you as I can't see your complete table
definitions, but I'd usually do this by using
 issue_id INTEGER REFERENCES issue ON DELETE CASCADE

in my column definition.

See [1] for more information.

[1]http://www.postgresql.org/docs/current/interactive/ddl-constraints.html#DDL-CONSTRAINTS-FK

pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Delete with join -- deleting related table entries?
Next
From: "BigSmoke"
Date:
Subject: Re: (NONE)