On 07/30/2015 08:59 AM, Sherrylyn Branchaw wrote:
From here: http://www.postgresql.org/docs/9.4/interactive/sql-copy.html "COPY can only be used with plain tables, not with views. However, you can write COPY (SELECT * FROM viewname) TO ...." Right, so you can COPY FROM a view, but not, as far as I can tell, TO a view, unless Alban found a workaround.
As to your other question: "Still curious why the triggers I'm writing won't fire before my statement errors out on copying to a view, or inserting an out-of-range timestamp, when the trigger would resolve all the illegal operations if it just fired first." See this thread: http://www.postgresql.org/message-id/AANLkTik6-sNYpAbiaZtipPJkqxbOrfVAZb1EFk0CNHYw@xxxxxxxxxxxxxx in particular this post: http://www.postgresql.org/message-id/24930.1276658060@xxxxxxxxxxxxx -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
