Re: BUG #18111: Query hangs when trying to INSERT empty string into NOT NULL table

On Fri, 15 Sept 2023 at 21:48, PG Bug reporting form
<noreply@postgresql.org> wrote:
> 1.CREATE TABLE texttable (col1 TEXT NOT NULL);
> 2.INSERT INTO texttable (col1) VALUES ('');
>
> Query hangs indefinitely.
> For NULL column it works as expected.

Does it still hang on a freshly created database?

Do you see any ungranted locks in pg_locks for the process ID of the
waiting backend?

select * from pg_locks where pid=NNN and not granted;

You can obtain the PID from the backend before you execute the query
that's going to hang with:

select pg_backend_pid();

Do you see any rows pg_event_trigger?:

select * from pg_event_trigger;

David