Problem using Embarcadero ER/Studio with Postgres (With Serial PK)

Posted by Paul on Stack Overflow See other posts from Stack Overflow or by Paul
Published on 2010-04-28T18:04:35Z Indexed on 2010/04/28 18:07 UTC
Read the original article Hit count: 295

Filed under:
|

Hello ...

I created a table using ER/STudio 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 )

© Stack Overflow or respective owner

Related posts about embarcadero

Related posts about sql