Re: CHECK that involves a function call behaves differently during bulk load?

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: Kirk Parker <khp@equatoria.us>

Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Date: 2025-03-13T22:52:42Z

Lists: pgsql-bugs

On Thu, Mar 13, 2025 at 3:33 PM Kirk Parker <khp@equatoria.us> wrote:

>
> (1) why does it work with individual inserts sent via psql, but not with
> the redirected input from the dump?
> (2) everything is in the public schema so why wouldn't it find the type
> anyway?
>
>
https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATTERNS

System maintenance and actions use a secure search_path.

David J.