Re: indexes on partitioned tables

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.
>>>>
>>>