Re: [HACKERS] rule for update view that updates/inserts into 2 tables

2008-04-14 Thread Martijn van Oosterhout
On Mon, Apr 14, 2008 at 06:03:27PM -0400, Chad Showalter wrote: > I've posted this on pgsql-general and pgsql-sql, and haven't got any > responses. If any of you would be able to take a look at this for me and > give some feedback, I'd be obliged. I saw it there too, but couldn't spot anything at

[HACKERS] rule for update view that updates/inserts into 2 tables

2008-04-14 Thread Chad Showalter
I've posted this on pgsql-general and pgsql-sql, and haven't got any responses. If any of you would be able to take a look at this for me and give some feedback, I'd be obliged. I would like to create a rule that, by updating a view, allows me to update one table and insert into another. T