| From: | Lewis Bergman <lbergman(at)[nospam] abi(dot)tconline(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | How to do a strange constraint |
| Date: | 2002-04-25 21:40:34 |
| Message-ID: | 200204252140.g3PLeYe06634@lewis.abi.tconline.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
At least it seems strange to me.
I have a customer_main table with all the usual stuff plus a column named
agent. An inherited table from customer_main has a couple of columns
describing each agent.
I need to make sure that a valid id from the inherited table agent is
populating the agent column in customer_main. Any ideas on how to do this? A
RESTRICT constraint from the customer_main.agent column to the
customer_main.id column just seems strange for some reason. Is this the right
solution?
--
Lewis Bergman
Texas Communications
4309 Maple St.
Abilene, TX 79602-8044
915-695-6962 ext 115
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug Silver | 2002-04-25 22:22:04 | faster join access? |
| Previous Message | Leandro Fanzone | 2002-04-25 19:13:41 | Index on wildcard text search |