Publication_id cannot be nulled

Software Support Open Monograph Press
, ,
11

Hi @asmecher, @fairuz and @rcgillis

DELETE FROM publication_formats WHERE publication_format_id in (SELECT pf.publication_format_id FROM publication_formats pf LEFT JOIN submissions s ON (pf.submission_id = s.submission_id) WHERE s.submission_id IS NULL);

I run this query before update.
Works for me!

Regards,
Tarcisio Pereira.

2 Likes