Re: Trigger is not working for Inserts from the application - Mailing list pgsql-general

On 09/10/2016 11:39 AM, Kiran wrote:
> Hi Adrian,
>
> Thanks for your response.
> I tried with logging. The application is inserting the record that I am
> passing into the database. But the trigger is not firing.

What is the text of the complete statement as it appears in the logs?

When you do the INSERT the other fields are the same in the database as
in the row, after the INSERT?

Related to second question, is the the INSERT being done in an explicit
transaction eg. BEGIN; INSERT something; and if so is there a COMMIT at
the end?

Have you tried with log_statement = 'all' to see if there are non-mod
statements running at the same time?


> I have been looking into this issue since morning with out any positive
> outcome :(.
> If you have any other tips, it will be really helpful.
>
> regards
> Kiran
>
> On Sat, Sep 10, 2016 at 3:22 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 09/10/2016 03:59 AM, Kiran wrote:
>
>         Hi,
>
>         *Problem background :*
>         I have a *function in the DB* as follows
>         CREATE FUNCTION question_tsv_trigger() RETURNS trigger AS
>         $BODY$
>         begin
>         New.weighted_tsv :=
>         to_tsvector('swedish',coalesce(New.body->>'qtext','')::text);
>         RAISE NOTICE 'TRIGER called on %', TG_TABLE_NAME;
>         return New;
>         end
>         $BODY$
>         LANGUAGE plpgsql VOLATILE
>         COST 100;
>
>         **Trigger in the DB:**
>         CREATE TRIGGER insert_upd_question_tsvector BEFORE INSERT OR UPDATE
>         ON myschema.cf_question
>         FOR EACH ROW EXECUTE PROCEDURE question_tsv_trigger();
>
>         If I insert a record from my application using following code :
>         db.myschema.cf_question.insert({
>         cf_question_type_id:request.pa <http://request.pa>yload.type_id,
>         cf_question_category_id:request.payload.cat_id,
>         lang:request.payload.lang,
>         body:request.payload.body
>         }
>
>         The above app code inserts the record in the DB, but the
>         respective trigger
>         in the database is not triggered hence the "weighted_tsv"
>         columns is empty
>         for this record.
>
>         But if I insert a record from the postgres psql, it will insert and
>         the respective trigger is working perfectly.
>
>         What could be the problem ? Why trigger is not working if I
>         insert from the
>         application ? Am I doing anything wrong ?
>         Any help would be really really appreciated.
>
>
>     If you have not, turn on log_statement:
>
>     https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
>     <https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT>
>
>     Then check your log to see what the application is sending to the
>     database.
>
>
>         Thanks
>         Kiran
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com