pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: whittard1@avaya.com
Subject: BUG #16431: Trigger not allowing new data insert
Date: Wed, 13 May 2020 02:37:55 +0000
Message-ID: <16431-22ae9a86f4e960e4@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16431
Logged by:          Matt Whittard
Email address:      whittard1@avaya.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;



Message-ID: <16431-22ae9a86f4e960e4@postgresql.org>
Permalink:  ../16431-22ae9a86f4e960e4@postgresql.org/
Also on:    postgresql.org/message-id/16431-22ae9a86f4e960e4@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, whittard1@avaya.com
  Subject: Re: BUG #16431: Trigger not allowing new data insert
  In-Reply-To: <16431-22ae9a86f4e960e4@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox