On 9/10/16 6:03 AM, Kiran wrote:
If I insert a record from my application using following code : db.myschema.cf_question.insert({ cf_question_type_id:request.payload.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 another record from the postgre's 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.
Without knowing what that app code is doing it's impossible to know. Try turning on logging of all statements (log_statement = ALL) and see what queries the app is actually running.
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
