Re: [ILUG-BOM] [OT} specifyin constraint in postgres

On 30/01/06 00:43 +0530, Puneet Lakhina wrote:

i m using postgresql... i want one of my columns to reference diff tables and refernece them in or relation wat i mean is

Please write in English.

that for the column foo in table foo_table the values should come from column ref1 in table 1 orref 2 in table 2 and so on

eg in foo_table id foo 1 123 (referneces table1) 2 124 (referneces table1) 3 223 (referneces table 2)

table 1 id ref1 otherfields id01 123 kasdhfaks id02 124 asdkjasl

table2 id ref2 02id01 223

so is there anyway i can specify these constraints

Use an explicit constraint check, or a trigger. Foreign keys will not work.

Devdas Bhagat