From: | Pete Leonard <pete(at)hero(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | stumped on view/rule/delete problem. |
Date: | 2001-06-11 21:12:36 |
Message-ID: | Pine.LNX.4.10.10106111411210.29717-100000@hero.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-06-11 21:33:44 | Re: What the heck is happening here? |
Previous Message | Paul Tomblin | 2001-06-11 21:06:51 | What the heck is happening here? |