[ic] Auto number-tuning

[interchange-users@icdevgroup.org (Stefan Hornburg Racke]

"Rene Hertell" <rene@hertell.com> writes:

> > 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

It is too long ago that I used PostgreSQL, but IMHO IC supports SQL-based
autonumbering with PostgreSQL too.

Ciao
        Racke

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT 
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or 
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.