Re: [SQL] loop on a rule

2001-08-07 Thread Martín Marqués
On Mar 07 Ago 2001 20:53, you wrote: > =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <[EMAIL PROTECTED]> writes: > > As I said before, I am playing around with views and rules, and found out > > that I have something wrong in one of the rules. My delete rule says > > something like this: > > > > CREATE RU

Re: [SQL] loop on a rule

2001-08-07 Thread Tom Lane
=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <[EMAIL PROTECTED]> writes: > As I said before, I am playing around with views and rules, and found out > that I have something wrong in one of the rules. My delete rule says > something like this: > CREATE RULE admin_delete AS ON > DELETE TO admin_view > D

[SQL] loop on a rule

2001-08-07 Thread Martín Marqués
As I said before, I am playing around with views and rules, and found out that I have something wrong in one of the rules. My delete rule says something like this: CREATE RULE admin_delete AS ON DELETE TO admin_view DO INSTEAD ( DELETE FROM carrera WHERE id_curso=old.id_curso; DELETE FROM