Re: keeping 3 tables in sync w/ each other

On Wed, 2007-09-19 at 11:05 +0100, Filip Rembiałkowski wrote:
> 2007/9/19, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>:
>
> (...)
>
> > simulate a delete
> > => delete from parent where id in (select id from child);
> > DELETE 6
> >
> > => select * from parent;
> > id | data1
> > ----+---------
> > 2 | parent2
> > 3 | parent3
> > 4 | parent4
> >
> > => select * from child;
> > id | data1
> > ----+-------
> > (0 rows)
> >
> Yes. You can however try
>
> SELECT FROM ... ONLY parent ...
> (that's what I used in example)
>
> and
> DELETE FROM ... ONLY parent ...

Here's the obigatory Ooohhh or the simpson's "Doh!"

Let me re-try this and see how it goes.

Many thanks for the Ooo... ( I feel like the "green aliens" in Toy
Story)