pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Otakar Kleps <kleps@avonet.cz>
To: pgsql-sql@postgresql.org
Subject: Help with RULE
Date: Tue, 13 Nov 2001 09:28:58 +0100
Message-ID: <3BF0D9CA.7050807@avonet.cz> (raw)

On Postgres 7.1.3(SUSE Linux 7.0 - 2.2.16) I have this problem:

I have table, for example:

CREATE TABLE tbl_test(
id INTEGERE PRIMARY KEY,
...
_parent INTEGER REFERENCES tbl_test ON DELETE CASCADE,
...
)

Next, I create rule for table tbl_test on event ON DELETE:
CREATE RULE rule_test AS ON DELETE TO tbl_test DO INSERT INTO ...;

Why RULE doesn't DELETE recursive(for a consideration REFERANCES)!?

Please HELP ME!

Thank you

-- 
Otakar KLEPS               AVONET, s.r.o.
-----------------------------------------
tel./fax:  067/7217797
e-mail:    kleps@avonet.cz
http://www.avonet.cz   http://www.zlin.cz




view thread (3+ messages)  latest in thread

Message-ID: <3BF0D9CA.7050807@avonet.cz>
Permalink:  ../3BF0D9CA.7050807@avonet.cz/
Also on:    postgresql.org/message-id/3BF0D9CA.7050807@avonet.cz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: kleps@avonet.cz
  Subject: Re: Help with RULE
  In-Reply-To: <3BF0D9CA.7050807@avonet.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox