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
