[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