From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Mathias Seiler" <mathias(dot)seiler(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4141: Aliases in rules vanished, but they work |
Date: | 2008-05-03 21:52:13 |
Message-ID: | 24870.1209851533@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Mathias Seiler" <mathias(dot)seiler(at)gmail(dot)com> writes:
> postgres=# CREATE RULE foo_delete AS ON DELETE TO foo_view do instead
> postgres-# DELETE FROM foo f where f.id = old.id;
> CREATE RULE
> postgres=# \d foo_view
> View "public.foo_view"
> Column | Type | Modifiers
> --------+---------+-----------
> id | integer |
> bar | text |
> View definition:
> SELECT foo.id, foo.bar
> FROM foo
> LIMIT 10;
> Rules:
> foo_delete AS
> ON DELETE TO foo_view DO INSTEAD DELETE FROM foo
> WHERE f.id = old.id
Hmm, looks like ruleutils.c got overlooked in the patch that added
support for aliases on UPDATE/DELETE target relations. Will fix.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Ottaway | 2008-05-04 12:04:15 | BUG #4142: pg_dump will not work |
Previous Message | Mathias Seiler | 2008-05-03 21:27:16 | BUG #4141: Aliases in rules vanished, but they work |