Embarcadero ER/Studio Physical Model generated convert the Serial to Integer
I created a table using ER/STudi开发者_如何学Pythono 8.0.3 ... The table has a serial pk (SERIAL/INTEGER in ER/Studio)... But the ER/Studio Physical Model generated convert the Serial to Integer... And The generated table in database has a integer pk, without auto-increment functionality...
Any idea?
Table generated :
CREATE TABLE test
(
id integer NOT NULL
)
Should be :
CREATE TABLE test
(
id serial NOT NULL
)
ER-Studio only generates SQL-Server code, even the mySQL generated code needs manual corrections. Try Datanamic Dezign over 6.
Does not work with PostgreSQL...
精彩评论