Re: How to insert into 2 tables from a view? - Mailing list pgsql-general

From David G Johnston
Subject Re: How to insert into 2 tables from a view?
Date
Msg-id 1419366138642-5831897.post@n5.nabble.com
Whole thread Raw
In response to Re: How to insert into 2 tables from a view?  (Chris Hoover <revoohc@gmail.com>)
Responses Re: How to insert into 2 tables from a view?
List pgsql-general
Chris Hoover-2 wrote
> Sorry, in my haste to get the example out, a couple of typo's where in the
> sql.

Next time, don't quote the entire original wrong query...

Anyway, you probably want to create a trigger on your view and do the
inserts inside the trigger function.

User created CREATE RULE is not usually the correct answer to a problem.

David J.



--
View this message in context:
http://postgresql.nabble.com/How-to-insert-into-2-tables-from-a-view-tp5831876p5831897.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Chris Hoover
Date:
Subject: Re: How to insert into 2 tables from a view?
Next
From: David G Johnston
Date:
Subject: Re: How to insert into 2 tables from a view?