Design database - Mailing list pgsql-admin

From Mai Peng
Subject Design database
Date
Msg-id FDD700F1-0FC8-4242-9C55-9D2CC590F71D@webedia-group.com
Whole thread Raw
Responses Re: Design database  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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




pgsql-admin by date:

Previous
From: João Gaspar
Date:
Subject: Re: [Question][PGAgent][Jobs] - Problems running sh scripts on remote Server
Next
From: Raj kumar
Date:
Subject: Sharding in Postgres