@Newskooler It is not only about the last partition. The thing is that the query gives back success msg but does nothing to the table
09/29/2022, 1:55 PM
Yeah - that happens when you try to drop the last partition. It does not fail.
09/29/2022, 1:57 PM
No, if I try to DROP last partition from another table I am getting an error msg "could not remove partition '2022-09-29'"
09/29/2022, 1:58 PM
yes… you’re correct. I remember now.
Then I don’t know 😕 I guess open a new issue about that.
09/29/2022, 2:00 PM
@Bolek Ziobrowski The query gives success message back, but no changes are applied to the table.
The '54709-05-18' is the last partition of the table of course but I am expecting an error if nothing is changed in the table. So I think the last option is the suggestion from Alex