Re: COPY FROM WHEN condition

Surafel Temsgen <surafel3000@gmail.com>

View thread View on postgr.es

From: Surafel Temesgen <surafel3000@gmail.com>

To: alvherre@2ndquadrant.com

Cc: tomas.vondra@2ndquadrant.com, Adam Berlin <berlin.ab@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2018-12-12T06:05:31Z

Lists: pgsql-hackers

Attachments

copy_from_when_con_v7.patch (text/x-patch) patch v7

On Tue, Dec 4, 2018 at 12:44 PM Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:

> After reading this thread, I think I like WHERE better than FILTER.
> Tally:
>
> WHERE: Adam Berlin, Lim Myungkyu, Dean Rasheed, yours truly
> FILTER: Tomas Vondra, Surafel Temesgen
>
>
>
accepting tally result  i change the keyword to WHERE condition and allow
volatile function
with single insertion method
regards
Surafel

Commits

Remove unused struct member, enforce multi_insert callback presence.
- 57a7a3adfe4e 12.0 landed
Separate per-batch and per-tuple memory contexts in COPY
- 36a1281f86c0 12.0 landed
Fix handling of volatile expressions in COPY FROM ... WHERE
- 4a8283d0ec5a 12.0 landed
Allow COPY FROM to filter data using WHERE conditions
- 31f3817402da 12.0 landed
Remove obsolete netbsd dynloader code
- b68ff3ea672c 12.0 cited