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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Kirk Parker <khp(at)equatoria(dot)us>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: CHECK that involves a function call behaves differently during bulk load?
Date: 2025-03-13 22:52:42
Message-ID: CAKFQuwYwmd0EEo0vXtJy+TRA-RC3RbbGLvsT6fpALWewqqgDag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Mar 13, 2025 at 3:33 PM Kirk Parker <khp(at)equatoria(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-03-14 00:19:42 Re: BUG #18839: ARMv7 builds fail due to missing __crc32cw and similar
Previous Message Kirk Parker 2025-03-13 22:33:33 Re: CHECK that involves a function call behaves differently during bulk load?