Hello!
I have just joined this mailing list, so please do not become frustrated, if I happen to ask
something that has already been answered recently.
There is a thing, which didn't work as I expected, so maybe you could tell me, what have I done
wrong?
There are 2 tables:
museums (museum_id int2, description text, address_id int2)
addresses (address_id int2, address text);
(they are actually a bit different, the museums.museum_id & address.address_id being unique
indices with default values from sequences etc.)
I want to delete museum's address from addresses when I delete something from museums.
So I thought to do it with a rule:
CREATE RULE museumdel ON DELETE TO museums DO DELETE FROM addresses WHERE
addresses.address_id=current.address_id;
Now, when I do DELETE FROM museums, the psql monitor displays DELETE 0 and when I
check the tables, the proper entry from museums IS deleted, but the associated addresses row
is not.
What am I doing wrong?
Thanks in advance for any ideas & tips!
Emils Klotins e-mail: emils@mail.usis.bkc.lv
Systems Manager URL: http://www.usis.bkc.lv/
USIS Riga 7 Smilsu Str., Riga LV1050, LATVIA
......................................................
RSA PGP key published on: http://pgpkeys.mit.edu:11371