Design database

From: Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Design database
Date: 2021-02-03 15:23:33
Message-ID: FDD700F1-0FC8-4242-9C55-9D2CC590F71D@webedia-group.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thank you

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raj kumar 2021-02-03 15:32:42 Sharding in Postgres
Previous Message João Gaspar 2021-02-03 11:00:48 Re: [Question][PGAgent][Jobs] - Problems running sh scripts on remote Server