| From: | "Paulo Roberto Siqueira" <paulo(dot)siqueira(at)usa(dot)net> |
|---|---|
| To: | "PGSQL Novice" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Triggers? |
| Date: | 2000-08-19 23:29:43 |
| Message-ID: | NEBBLMEAPMNMMCFDDILOGEFICCAA.paulo.siqueira@usa.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have two tables
alternativa1( id_altern int4 primary key, ....)
alternativa2( id_altern int4 primary key, ....)
I want a trigger that doesn't allow insertion of a value in one table if it
exists on the other, i.e., the following operation must be prevented:
insert into alternativa1 values(1,...)
insert into alternativa2 values(1,...)
Any suggestions on how i can implement this feature?
Paulo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Skinner | 2000-08-20 06:00:56 | pg_dump and large object? |
| Previous Message | Tom Lane | 2000-08-19 04:39:48 | Re: Third email on compilining 7.0.2 on Solaris 2.5.1 |