Re: table partition with inheritance having current_timestamp issue if we miss range table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: table partition with inheritance having current_timestamp issue if we miss range table
Date
Msg-id 1750081.1600282298@sss.pgh.pa.us
Whole thread Raw
In response to table partition with inheritance having current_timestamp issue if we miss range table  (Nagaraj Raj <nagaraj.sf@yahoo.com>)
Responses Re: table partition with inheritance having current_timestamp issue if we miss range table  (Nagaraj Raj <nagaraj.sf@yahoo.com>)
List pgsql-bugs
Nagaraj Raj <nagaraj.sf@yahoo.com> writes:
> How to reproduce the issue,
> 1. Create a table partition with table inheritance by range on the date column2. Place triggers and trigger
function3.In the trigger function, update with inheritance tables from September to December or appropriate.4. while
creating inheritancetables, skip one of the tables which updated in the trigger function5. If you started to insert, it
wouldwrite into the master table with a future date. 

TBH, I strongly doubt that anyone is going to follow up on this report
as given.  It seems at least as likely that the bug is in your trigger
code as in Postgres proper.  Without the exact schema and trigger code,
anyone who did try couldn't be sure whether failure to see something
interesting means that there's no Postgres bug or just that they'd
failed to duplicate what you did.

If you'd like us to take an interest, please submit a *self contained*
test case.  Preferably a script that starts with an empty database,
creates all the requisite objects, and then does whatever is needed
to exhibit the misbehavior.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Nagaraj Raj
Date:
Subject: table partition with inheritance having current_timestamp issue if we miss range table
Next
From: Andrew Marynchuk (Андрей Маринчук)
Date:
Subject: Re: Strange output of XML attribute values