From: | Andrew Snow <andrew(at)modulus(dot)org> |
---|---|
To: | Pete Leonard <pete(at)hero(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: stumped on view/rule/delete problem. |
Date: | 2001-06-12 00:36:08 |
Message-ID: | 20010612103211.T91248-100000@esper.modulus.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hmm, what about this instead?
create table foo (
id serial primary key,
name text
);
create table bar (
foo_id integer NOT NULL REFERENCES foo ON DELETE CASCADE,
name2 text
);
create view foobar as
select f.id, f.name, b.name2 from foo f, bar b where (f.id = b.foo_id);
create rule delete_foobar as on delete to foobar do instead delete from foo
where id = OLD.id;
(works on v7.1.2)
- Andrew
On Mon, 11 Jun 2001, Pete Leonard wrote:
>
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Lucky | 2001-06-12 04:13:16 | libpq++ PgDatabase and PgConnection |
Previous Message | Tim Mickol | 2001-06-12 00:10:20 | pg_dumpall anomaly |