vertikalno particionisanje

CREATE TABLE public.passenger
(
    passenger_id integer NOT NULL,
    title character varying(10) COLLATE pg_catalog."default" NOT NULL,
    first_name character varying(100) COLLATE pg_catalog."default" NOT NULL,
    last_name character varying(100) COLLATE pg_catalog."default" NOT NULL,
    date_of_birth character varying(11) COLLATE pg_catalog."default" NOT NULL,
    sex character varying(10) COLLATE pg_catalog."default" NOT NULL,
    phone_number character varying(20) COLLATE pg_catalog."default",
    email character varying(50) COLLATE pg_catalog."default",
    CONSTRAINT passenger_pkey PRIMARY KEY (passenger_id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.passenger
    OWNER to postgres;


CREATE OR REPLACE FUNCTION passenger_insert_trigger()
RETURNS TRIGGER AS $$
BEGIN
    INSERT INTO person VALUES (NEW.passenger_id, NEW.first_name, NEW.last_name, NEW.title);
    INSERT INTO person_details VALUES (NEW.passenger_id, NEW.date_of_birth, NEW.sex, NEW.phone_number, NEW.email);

    RETURN NEW;
END;
$$
LANGUAGE plpgsql;

CREATE TRIGGER passenger_insert_trigger
BEFORE INSERT ON passenger
FOR EACH ROW EXECUTE PROCEDURE passenger_insert_trigger();