[ic] Auto number-tuning

Rene Hertell interchange-users@icdevgroup.org
Wed Jul 3 15:17:00 2002


> I suggest to use MySQL tables with auto_increment keys and AUTO_SEQUENCE 1
> in the IC Database settings. A similar method is probably available for
> other SQL databases.

Hi Racke!

I'm using postgres, and I tried to define my primary key as a serial field,
but it did not work out... Is there any other column type I should use to
get that autoincrement enabled?

This is how my definition looks like:

Database  links   DEFAULT_TYPE    text
Database  links   COLUMN_DEF      "code=SERIAL NOT NULL PRIMARY KEY"
Database  links   AUTO_SEQUENCE   1


Regards, Rene