stumped on view/rule/delete problem. - Mailing list pgsql-general

Hey folks,

Still learning the ins and outs of postgres, and I'm stumped on this
problem - was hoping someone here could help.

create table foo (
id    serial,
name    varchar(50)
);

create table bar (
foo_id    integer,
name2    varchar(50)
);

create view foobar as
select f.id, f.name, b.name2 from foo f, bar b where (f.id = b.foo_id);


now -

create rule delete_foobar as on delete to foobar
do instead (
delete from foo where id=OLD.id;
delete from bar where foo_id = OLD.id;
);

running the command
delete from foobar where id=1;

causes the DB to hang.  only way out is an immediate restart of the DB.

Needless to say, this isn't the functionality I was looking for.  :)

Postgres v. 7.1, running under FreeBSD.

    thanks,

    --pete