Re: table partition with inheritance having current_timestamp issue if we miss range table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: table partition with inheritance having current_timestamp issue if we miss range table
Date: 2020-09-16 18:51:38
Message-ID: 1750081.1600282298@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)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 inheritance tables, skip one of the tables which updated in the trigger function5. If you started to insert, it would write 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Marynchuk (Андрей Маринчук) 2020-09-16 20:23:03 Re: Strange output of XML attribute values
Previous Message Nagaraj Raj 2020-09-16 18:22:54 table partition with inheritance having current_timestamp issue if we miss range table