Aftab Alam wrote:
> Hello,
>
> I want to create a trigger in PostgresSQL
>
> In trigger, Before inserting the record, if data is already in the table,
> the trigger fire the mesaage that data is already there, and after that
> trigger ckeck for next insert statement.
Aftab - can you explain in some more detail. Raising an error on an
insert will happen automatically if you violate a unique constraing.
What is this "next insert statment" you're talking about?
--
Richard Huxton
Archonet Ltd
