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/[email protected]
in particular this post:
http://www.postgresql.org/message-id/[email protected]
--
Adrian Klaver
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
