On Wed, Feb 3, 2021 at 8:23 AM Mai Peng <maily.peng@xxxxxxxxxxxxxxxxx> wrote:
Hello,
I’ve got a table name publication, and another table named publication_item.
Each publication_item is linked to a publication by publication_id.
How could I add a constraint that check each publication has one or more publication_item when a tuple is inserted ?
I don’t want to store items in the same table as publication because we could have 1-> n items.
David J.