auto increment for attribute value type of int and bigint for primary key

usr338

Hi, i wonder how can i use bigint as primary key value type in Rei3. i have an append-only table with 10 record in a sec. how can i use bigserial (bigint) as primary key ?
also one of the column in table need to be auto incremented by database. how can i specify that in new attribute form of Rei3 relations?

gabriel

To switch to an auto-incrementing bigint PK, you open the id attribute and select the option "large values". It will display bigint as database type.

We would need to add a serial attribute type to r3 to make this straightforward; currently, you´d use an insert trigger to generate the next ID. If you index this attribute and make it unique, it works the same as a regular auto-increment.

usr338

Oh sorry for being careless, I don't know why I thought I couldn't change any property of the default Id. And thanks for your suggestion about the serial replacement operation.