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-snypabiaztippjkqxborfvazb1efk0cn...@mail.gmail.com
in particular this post:
http://www.postgresql.org/message-id/24930.1276658...@sss.pgh.pa.us
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
