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 :-)
--
... _._.
[EMAIL PROTECTED] wrote:
I have three tables --
CREATE TABLE name (id INT PRIMARY KEY, str VARCHAR(20));
CREATE TABLE place (id INT PRIMARY KEY, name_id INT REFERENCES name(id));
CREATE TABLE data (id INT PRIMARY KEY, place_id INT REFERENCES place(id));
I want to delete all place an
I have three tables --
CREATE TABLE name (id INT PRIMARY KEY, str VARCHAR(20));
CREATE TABLE place (id INT PRIMARY KEY, name_id INT REFERENCES name(id));
CREATE TABLE data (id INT PRIMARY KEY, place_id INT REFERENCES place(id));
I want to delete all place and data rows which reference
