https://bugs.documentfoundation.org/show_bug.cgi?id=60643

--- Comment #19 from Alex Thurgood <[email protected]> ---
Still present in 

Version: 25.8.3.2 (AARCH64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 8; OS: macOS 26.1; UI render: Skia/Metal; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded


The wizard UI sets the NOT NULL constraint and defines the ID column as the
KEY, but does not set the AUTOINCREMENT or SERIAL instruction, even when this
option is ticked.


Error message when attempting to manually insert a record without introducing a
manual INT value for ID:

pq_driver: [PGRES_FATAL_ERROR]ERROR:  null value in column "ID" of relation
"Plantes" violates not-null constraint
DETAIL:  Failing row contains (null, Arum, Found in wood out back, null, 32,
Lilium, t, Goosefoot, null, 2023-02-23, null, null, 2023-01-31, Dobbies, null,
null, null, null).
 (caused by statement 'INSERT INTO "public"."Plantes" (
"DateAchat","DatePlantation","Espèces","Floraison","Genre","LieuAchat","NomCommun","Notes","RéfPlante")
VALUES (
'2023-01-31','2023-02-23','Lilium','t','Arum','Dobbies','Goosefoot','Found in
wood out back','32')')

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to