Interchange Developer Resource
[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] Auto number-tuning



> 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




Search for: Sort by: