Re: Question about copy from with timestamp format - Mailing list pgsql-general

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@mail.gmail.com

in particular this post:

http://www.postgresql.org/message-id/24930.1276658060@sss.pgh.pa.us


--
Adrian Klaver
adrian.klaver@aklaver.com