Postgre table id column

rakics's profile image rakics posted 2 weeks ago in General Permalink

Hi,

I have Python project wit ORM for creating sql tables for PostgreSQL and MySql, when I create with Python sql tables I get wrong id column definition:

MySql: CREATE TABLE contact_us ( id BIGINT NOT NULL AUTO_INCREMENT,

PostgreSQL: CREATE TABLE "contact_us" ( "id" SERIALNOT NULL,

fix will be to add space between SERIALNOT:

CREATE TABLE "contact_us" ( "id" SERIAL NOT NULL,

This happends for tab [</> create CODE]

Best Regards, Sasa

Code modification/commit 50325ea from Ansgar Becker <anse@heidisql.com>, 2 weeks ago, revision 12.17.0.7290
fix: space missing in CREATE TABLE code of PG table with SERIAL column

See https://www.heidisql.com/forum.php?t=45094
ansgar's profile image ansgar posted 2 weeks ago Permalink

Yes, can confirm. Should be fixed in the next build.

Please login to leave a reply, or register at first.