Re: Trigger function which inserts into table; values from lookup

OK, but, how do I set this up to do what I need? I want an insert that would
create a dupe key to be rolled back, and inserts that would not create dupe
keys to be committed.



Tom Lane-2 wrote:
>
> novnov <novnovice@gmail.com> writes:
>> Any clue re my question?
>
> You've placed the INSERT inside the BEGIN/EXCEPTION block, ergo it's
> part of the work to be rolled back on exception.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>

--
View this message in context:
http://www.nabble.com/Trigger-function-which-inserts-into-table--values-from-lookup-tf3784731.html#a10713002
Sent from the PostgreSQL - general mailing list archive at Nabble.com.