Skip site navigation (1) Skip section navigation (2)

cascade delete

From: Jagadeesh <mnjagadeesh(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: cascade delete
Date: 2008-11-17 11:06:54
Message-ID: 2463901b-c937-467e-a385-6c9e4ac20a1c@a17g2000prm.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-admin
is there any way to  delete records  based on condition? something
similar to  truncate <table name> cascade;
I tried delete <table name> where id=12 cascade;
but didn't work. I am not thinking of changing the constraint to 'on
delete'

Thanks
Jagadeesh

pgsql-admin by date

Next:From: Ben WebberDate: 2008-11-17 13:45:43
Subject: Re: Change in logging behaviour between 8.1 and 8.2
Previous:From: JagadeeshDate: 2008-11-17 11:02:20
Subject: Re: how to invoke edtor?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group