CREATE TABLE types
(
  type_id integer NOT NULL Primary Key,
  type_label text NOT NULL
);

INSERT INTO types
(type_label)
VALUES 
('Бла1'),
('Бла2'),
('Бла3'),
('Бла4'),
('Бла5'),
('Бла6');

ERROR: null value in column "type_id" violates not-null constraint
SQL state: 23502

create table types
(
  type_id serial primary key,
  type_label text NOT NULL
);

CREATE SEQUENCE types_ser_type_ser_seq;
CREATE TABLE types (
    type_id integer NOT NULL Primary Key DEFAULT nextval('types_ser_type_ser_seq'),
    type_label text
);
ALTER SEQUENCE types_ser_type_ser_seq OWNED BY types.type_id;