Re: indexes on partitioned tables

And you can't copy the command and the error message?

On Fri, Jul 12, 2024 at 3:47 PM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:

> Sorry there is no error it's a pgadmin that says no index is on the
> partition table for reindexing.
>
> On Sat, 13 Jul, 2024, 1:11 am Zaid Shabbir, <zaidshabbir(at)gmail(dot)com> wrote:
>
>> Hello Ron,
>>
>> Can you plz provide some details about your scenario like
>> Platform, PostgreSQL version, table details and queries you use.
>>
>> Above information helps to identify the scenario and possible solution.
>>
>>
>> Thanks
>>
>>
>> On Sat, 13 Jul 2024 at 12:36 AM, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
>> wrote:
>>
>>> "and I can see indexes are created on child tables too."
>>>
>>> That's what's supposed to happen.
>>>
>>> As for errors... you haven't shown us any actual errors, only vague
>>> descriptions.
>>>
>>> On Fri, Jul 12, 2024 at 1:31 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
>>>
>>>> Hi Ron
>>>>
>>>> I created the indexes on the parent table globally and ran the create
>>>> script with partitioned tables script, the parent table with child tables
>>>> are created and I can see indexes are created on child tables too.
>>>>
>>>> Then I inserted data from existing table.
>>>>
>>>> Thanks,
>>>> Wasim
>>>>
>>>> On Thu, 11 Jul, 2024, 6:09 pm Ron Johnson, <ronljohnsonjr(at)gmail(dot)com>
>>>> wrote:
>>>>
>>>>> On Thu, Jul 11, 2024 at 4:16 AM Wasim Devale <wasimd60(at)gmail(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> I have partitioned a table and levied indexes on it but when I do
>>>>>> maintenance activities like reindexing it's not happening and the error is
>>>>>> index not present on the partitioned table.
>>>>>>
>>>>>> Please highlight some points on it, Is I am missing something?
>>>>>>
>>>>>
>>>>> Show us the code. Maybe you're doing "CREATE INDEX ... ON *ONLY*
>>>>> ...;" Or something else; we don't know, since your question is light on
>>>>> details.
>>>>>
>>>>