Triggers?

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: Raw Message | Whole Thread | 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

Browse pgsql-novice by date

  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