How can we help you today?
Alter Table Add Column not null does not correctly work
2 CommentsSorted by Oldest First
Roger Bjärevall
said
over 2 years ago
Thanks for informing me. I already saw it, as we bought a license for 13 last week.
Stephan Hradek
When I want to add a not-nullable column, the dialog generates this output:
"postgres"."public"."table" ADD COLUMN country CHARACTER VARYING(3);
ALTER TABLE
"postgres"."public"."table" ALTER COLUMN country SET NOT NULL;
ALTER TABLE
"postgres"."public"."table" ALTER COLUMN country SET DEFAULT 'GER'::CHARACTER VARYING
This "splitted statement" leads to an error because existing entries will have null values.
On the other hand. This statement would work:
"postgres"."public"."table" ADD COLUMN country CHARACTER VARYING(3) NOT NULL DEFAULT 'GER'::CHARACTER VARYING
Is that already fixed in V12? I'm sStill on V11.