NOT NULL violation error handling in file_fdw

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-03-12T10:21:06Z
Lists: pgsql-hackers

Attachments

According to the following documentation on IterateForeignScan() in
50.2. Foreign Data Wrapper Callback Routines, I have created a patch to
support the error handling in file_fdw.  Please find attached a patch.

    Note that PostgreSQL's executor doesn't care whether the rows
    returned violate the NOT NULL constraints which were defined
    on the foreign table columns - but the planner does care, and
    may optimize queries incorrectly if NULL values are present
    in a column declared not to contain them. If a NULL value is
    encountered when the user has declared that none should be
    present, it may be appropriate to raise an error (just as you
    would need to do in the case of a data type mismatch).

Best regards,
Etsuro Fujita