Postgres Table is foreign key to multiple tables

Question

I have a situation and would appreciate some help.
I have two tables - Error and Warning:

Error   : Err_no, pattern(pk=Error_no)
Warning : War_no, pattern(pk=War_no)

Based on these tables I have to decide on the resolution and I have a separate table doing this:

Resolution : Code_no, resolution

I want to keep Code_no as foreign key to both Err_no(Error table) and War_no(Warning table). I am using Postgres and want to know if and how I can do that?

Will A · Accepted Answer · 2010-07-29 19:13:04Z

2

A foreign-key can reference one-and-only-one primary-key table - so you won't be able to have Code_no reference both tables.

answered Jul 29, 2010 at 19:13

Will A

25k5 gold badges54 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tinychen · Accepted Answer · 2010-07-30 01:29:50Z

0

You can redesign you tables,merge tables Error and Warning to one table:Message

Message:(Msg_no,parrern,type(pk=Msg_no))

using column type to distinguish error or warning.then you can keep Code_no as foreign key to Message(Msg_no).

answered Jul 30, 2010 at 1:29

tinychen

2,0992 gold badges13 silver badges8 bronze badges

1 Comment

daydreamer Over a year ago

yeah, I guess redesign would be a better option, thanks for pointing it out

Collectives™ on Stack Overflow

Postgres Table is foreign key to multiple tables

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related