Script generated by ERD Tool don't reproduce geometry type.

[fguerra06]

Hello

Describe the bug

Script generated by ERD Tool don't reproduce geometry type.

To Reproduce

Steps to reproduce the behavior:

1:
CREATE TABLE IF NOT EXISTS test.point
(
id_point character varying(500) COLLATE pg_catalog."default" NOT NULL,
fk_polyg character varying(500) COLLATE pg_catalog."default",
geom geometry(Point,2154)
);

2: Right click on schema "test" ; "create ERD from schema"
3. On ERD : click on "generate SQL"
4. See the error :
-- This script was generated by the ERD tool in pgAdmin
BEGIN;
CREATE TABLE IF NOT EXISTS test.point
(
id_point character varying(500) COLLATE pg_catalog."default" NOT NULL,
fk_polyg character varying(500) COLLATE pg_catalog."default",
geom geometry
);
END;

Expected behavior

Reproduice the geometry type (point) and the EPSG (2154)

Desktop (please complete the following information):

• OS: [ Windows ]
• Version: [PGadmin 8.14]

Thank you for your help if the bug source is me :)

[adityatoshniwal]

The actual problem is with the table dialog where extra info for the geometry column cannot be entered/missing. And so ERD is not able to generate the SQL as info is not available.

[fguerra06]

Thank you for your answer adityatoshniwal,
Does it mean that I'm doing something wrong?

Fabien

[adityatoshniwal]

Thank you for your answer adityatoshniwal, Does it mean that I'm doing something wrong?

No, I just mentioned the root cause of the issue. It still is a bug and need to be fixed.