Bug: Postgres Create Table Scripting puts GENERATED BY DEFAULT AS IDENTITY on all columns

[kpconnell]

Describe the bug

Describe the bug
When scfripting a table create for PG Sql the tool puts GENERATED BY DEFAULT AS IDENTITY on all columns

To Reproduce
Script a postgres table

Expected behavior
A valid table creation DDL to be produced

Screenshots

Additional details
Enter any additional details we should know about.

Product

SQLPro Studio

App version

Version 2024.13 (Build 111086)

Platform

macOS

Installation source

App Store

[kpconnell]

Apologies this appears to be resolved in 2025.78, although it still does not properly create the sequence for id columns.. it would be better if it simply did not try to use a sequence and just did generated by default as identity..

[hankinsoft]

Apologies this appears to be resolved in 2025.78, although it still does not properly create the sequence for id columns.. it would be better if it simply did not try to use a sequence and just did generated by default as identity..

Could you possibly provide me with an example of the output you are receiving and an example of what you would expect to receive? I'm not quite understanding 100% and that should help me out.

[kpconnell]

In the below, the sequence might not exist as we're off to create this table in another database. It would be better to add:

CREATE SEQUENCE IF NOT EXISTS audit_log_audit_id_seq;

BEGIN;

CREATE TABLE IF NOT EXISTS public.audit_log (
audit_id bigint DEFAULT nextval('audit_log_audit_id_seq'::regclass) NOT NULL,
changed_at timestamp with time zone DEFAULT now() NOT NULL,
op character(1) NOT NULL,
schema_name text NOT NULL,
table_name text NOT NULL,
pk text NOT NULL,
db_user text DEFAULT CURRENT_USER NOT NULL,
app_user text,
txid bigint DEFAULT txid_current() NOT NULL,
old_row jsonb,
new_row jsonb,
changed_fields jsonb,
PRIMARY KEY(audit_id)
);

COMMIT;