Toad World® Forums

PostGreSQL 8.4 Serial Type child Attribute only Integer?


#1

{TDM 3.6.2.2}

Hi,

Working on a PostGreSQL 8.4 database, I see that the Serial attribute type is set to Integer in the Child entity, but I cannot seem to change this to BigInt for example.

Any suggestions, or is running a script for changes the best bet for now?

Regards,
Rudi


#2

Hi Rudi,

Sorry, TDM doesn’t allow you to have different data types in parent and child entity.
BTW, Serial is an alias of type Integer. If you want to have BigInt type in child entity, you have to select BigSerial type in parent entity. This is the only way.

If you have more questions, please write me back. Thanks.

Regards,

Vladka + TDM Team