Re: COPY FROM WHEN condition

Surafel Temsgen <surafel3000@gmail.com>

From: Surafel Temesgen <surafel3000@gmail.com>
To: tomas.vondra@2ndquadrant.com
Cc: berlin.ab@gmail.com, pgsql-hackers@lists.postgresql.org
Date: 2018-11-23T11:14:32Z
Lists: pgsql-hackers

Attachments

On Sun, Nov 11, 2018 at 11:59 PM Tomas Vondra <tomas.vondra@2ndquadrant.com>
wrote:

>
> So, what about using FILTER here? We already use it for aggregates when
> filtering rows to process.
>
> i think its good idea and describe its purpose more. Attache is a patch
that use FILTER instead
regards
Surafel

Commits

  1. Remove unused struct member, enforce multi_insert callback presence.

  2. Separate per-batch and per-tuple memory contexts in COPY

  3. Fix handling of volatile expressions in COPY FROM ... WHERE

  4. Allow COPY FROM to filter data using WHERE conditions

  5. Remove obsolete netbsd dynloader code