Hello,
When creating a serial, a sequence is created automatically.
CREATE TABLE tablename ( colname SERIAL );
CREATE SEQUENCE tablename_colname_seq; CREATE TABLE tablename ( colname integer NOT NULL DEFAULT nextval('tablename_colname_seq') ); ALTER SEQUENCE tablename_colname_seq OWNED BY tablename.colname;
Should not a proper permissions based on the table privileges added to the sequence ?. For example, when a table has INSERT, UPDATE permissions on the table to a certain user, this should be taken into account.
Regards