Ok, me decido por añadir la nueva tabla intermedia.
Código:
CREATE TABLE rel_pl_actp
(
pl_id integer,
actp_id integer,
id_rel oid NOT NULL,
CONSTRAINT pk_rel PRIMARY KEY (id_rel ),
CONSTRAINT rel_pl_actp_actp_id_fkey FOREIGN KEY (actp_id)
REFERENCES acces_tipus (actp_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT rel_pl_actp_pl_id_fkey FOREIGN KEY (pl_id)
REFERENCES platja_cala (pl_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
Es correcto crearla así? Gracias!