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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin