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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: maciej(dot)klimkowicz(at)oxla(dot)com
Subject: BUG #18111: Query hangs when trying to INSERT empty string into NOT NULL table
Date: 2023-09-15 09:00:31
Message-ID: 18111-1b3e19f428f1c418@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18111
Logged by: Maciej Klimkowicz
Email address: maciej(dot)klimkowicz(at)oxla(dot)com
PostgreSQL version: 15.1
Operating system: Ubuntu
Description:

Steps to reproduce:

1.CREATE TABLE texttable (col1 TEXT NOT NULL);
2.INSERT INTO texttable (col1) VALUES ('');

Query hangs indefinitely.
For NULL column it works as expected.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2023-09-15 10:00:19 Re: BUG #18111: Query hangs when trying to INSERT empty string into NOT NULL table
Previous Message Laurenz Albe 2023-09-15 07:06:13 Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore