Is it possible for a query to delete a record and all of its
foreign-key dependents?
I see DROP CASCADE, but not a DELETE CASCADE.
What I'm trying to do:
I have a clients table.
I have many different tables that use the clients.id as a foreign key.
When I delete a client, I want it to delete all
Miles Keaton wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
I see DROP CASCADE, but not a DELETE CASCADE.
What I'm trying to do:
I have a clients table.
I have many different tables that use the clients.id as a foreign key.
When I delete a client, I
On Thu, 30 Dec 2004 11:10:38 -0800, I wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
Sorry - to be more clear : I like having my foreign keys RESTRICT from
this kind of cascading happening automatically or accidently.
So I'm looking for a query
On Thu, 2004-12-30 at 11:10 -0800, Miles Keaton wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
I see DROP CASCADE, but not a DELETE CASCADE.
What I'm trying to do:
I have a clients table.
I have many different tables that use the clients.id as
On Thu, Dec 30, 2004 at 11:40:21 -0800,
Miles Keaton [EMAIL PROTECTED] wrote:
On Thu, 30 Dec 2004 11:10:38 -0800, I wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
Sorry - to be more clear : I like having my foreign keys RESTRICT from
this
Cool. Thanks for all the advice, guys.
I'll just keep my script manually deleting dependencies, then. It
gives me peace of mind.
:-)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster