Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger function which inserts into table; values from lookup - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger function which inserts into table; values from lookup
Date
Msg-id 28102.1179719006@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trigger function which inserts into table; values from lookup  (novnov <novnovice@gmail.com>)
Responses Re: Trigger function which inserts into table; values from lookup
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: novnov
Date:
Subject: Re: Trigger function which inserts into table; values from lookup
Next
From: "Conor McTernan"
Date:
Subject: User permissions/Data separation.