BUG #16431: Trigger not allowing new data insert

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: whittard1(at)avaya(dot)com
Subject: BUG #16431: Trigger not allowing new data insert
Date: 2020-05-13 02:37:55
Message-ID: 16431-22ae9a86f4e960e4@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16431
Logged by: Matt Whittard
Email address: whittard1(at)avaya(dot)com
PostgreSQL version: 12.1
Operating system: REHL 7.5
Description:

Hello PG admins,
I have 2 databases created with the below Trigger function code. Working
fine on the first DB I created but on the second no new data can be inserted
if the Trigger is enabled.
Trigger Fires is set to After with INSERT. If the Trigger is disabled or
deleted new row data can be inserted via ODBC. Trying to understand why on
this new database this is failing
timestamp column is set the same on both database Table Columns (set as
timestamp with timezone).
This will be a high traffic database and need to keep the row data trim -
will increase the limit after find root cause as required by corporate
compliance.
The tables both have the same configuration with postgresql as the owner
with all grant options.
This configuration was created using pgadmin version 4.18 on both databases,
same server and single instance.
Any ideas on best way to troubleshoot will be greatly appreciated.

Trigger Function Code
BEGIN
DELETE FROM call_reporting.public.call_info WHERE timestamp < NOW() -
INTERVAL '30 days';
RETURN NULL;
END;

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurenz Albe 2020-05-13 03:56:18 Re: BUG #16419: wrong parsing BC year in to_date() function
Previous Message David G. Johnston 2020-05-13 01:09:39 Re: BUG #16419: wrong parsing BC year in to_date() function