Script Changes feature does not respect identity/sequence columns, causing NOT NULL constraint violation.

[ChandraSaiKarthik]

Steps to Reproduce:

1. Open a table with an identity column (e.g., category_id in public.categories).
2. Make changes and click Script Changes.
3. Execute the generated script.
4. Observe error: null value in column "category_id" violates not-null constraint.

Expected Behavior:
Generated script should omit identity column or use DEFAULT for insert.

Actual Behavior:
Script includes NULL for identity column, causing failure.

[mikeburgh]

can you share the ddl of the table.

[ChandraSaiKarthik]

Here is the DDL for the table:

--
-- PostgreSQL database dump
--

-- Dumped from database version 17.5
-- Dumped by pg_dump version 17.6

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_table_access_method = heap;

--
-- Name: Categories; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public."Categories" (
    "CategoryID" integer DEFAULT nextval('public.categories_categoryid_seq'::regclass) NOT NULL,
    "CategoryName" character varying(50),
    "Description" text,
    parent_category public.category_type,
    created_on timestamp without time zone,
    modified_on timestamp with time zone
);

--
-- Name: Categories PK_CategoryID; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Categories"
    ADD CONSTRAINT "PK_CategoryID" PRIMARY KEY ("CategoryID");

--
-- Name: Categories UK_CategoryName; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Categories"
    ADD CONSTRAINT "UK_CategoryName" UNIQUE ("CategoryName");

--
-- Name: idx_category_name; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX idx_category_name ON public."Categories" USING btree ("CategoryName");

--
-- PostgreSQL database dump complete
--

[ChandraSaiKarthik]

Found an defect while expanding the object tree for the sequences in postgres.
the closing bracket ")" is missing. attached the screenshot.

[mikeburgh]

I cannot replicate the issue with the inserting..

When I go to insert a row, it correctly puts the default value in the ID column (I renamed the table, but otherwise same script you provided):

So provided that's not changed, it wont try and include that col when I generate an insert script..

INSERT INTO public.default_nextval ("CategoryName", "Description", created_on, modified_on)
VALUES ('Name', NULL, NULL, NULL);

One thing I do notice, your screenshots show two different case's of categories (and "Categories") do you have two tables with the same name and different case by chance ?

I have fixed the display issue in the tree for the default value.

[ChandraSaiKarthik]

both tables are same except case sensitive name difference.

[mikeburgh]

Version 1.17.33 includes the fix for the tree.. and I cannot reproduce the editing issue you are seeing.. if you can with a simple table DDL that you can share I can look into it.. but my guess at this stage is your two tables are not the same.. and lower case categories does not have a default/identity set.