different ID PRIMARY in diagramm and SQL Editor

[rlsoft80]

Hello,
There are a diffèrent KEY PRIMARY
In the diagramm : this is "id"
In the exportation SQL : this id "id_corps_metier"
I think, the export SQL take the first integer column after id

[adityatoshniwal]

Hi @rlsoft80,
I tried all possible ways to reproduce this, and it works fine for me. Can you share some reproducible steps and pgerd file as well?

BEGIN;


CREATE TABLE IF NOT EXISTS other.test
(
    id integer,
    id_corps integer,
    PRIMARY KEY (id)
);
END;

[rlsoft80]

Hello I join the file pgerd When I execute the script SQL, I have a bad primary key Thank's for help Romain LECOMTE Le mer. 28 févr. 2024 à 13:13, Aditya Toshniwal ***@***.***> a écrit :

…

Hi @rlsoft80 <https://github.com/rlsoft80>, I tried all possible ways to reproduce this, and it works fine for me. Can you share some reproducible steps and pgerd file as well? image.png (view on web) <https://github.com/pgadmin-org/pgadmin4/assets/31855755/ec49b9bc-789a-4358-a909-bd737788822e> BEGIN; CREATE TABLE IF NOT EXISTS other.test ( id integer, id_corps integer, PRIMARY KEY (id) ); END; — Reply to this email directly, view it on GitHub <#7229 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BGKNQKYAGSSFHMX2CNEEICTYV4NORAVCNFSM6AAAAABDTEMEC6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRYHA2TKMJWGA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[anilsahoo20]

Tested and verified on snapshot build: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2024-03-11/
Environment: macOs ventura 13.5.1
package: arm64