Re: auto-increment field : in a simple way

Can't you just add this to your create table:

CREATE TABLE tablename (
   colname SERIAL

, check (colname>0 and colname < 32768));
);