Re: Include schema-qualified names in publication error messages.

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc: Euler Taveira <euler(at)eulerto(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: Include schema-qualified names in publication error messages.
Date: 2026-05-04 05:21:07
Message-ID: CAJpy0uD2CM07uAHkJR4ELkZdYpXyF0vP9=WGK-=8Z_GK7mu0Sg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Apr 30, 2026 at 7:23 PM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>
> On Thu, 30 Apr 2026 at 7:14 PM, Euler Taveira <euler(at)eulerto(dot)com> wrote:
>>
>>
>>
>> On Thu, Apr 30, 2026, at 4:37 AM, Dilip Kumar wrote:
>> >
>> > Yeah we may, but I feel what we have now looks more readable.
>> >
>>
>> My suggestion is that this function should be available in a central place.
>> That's not the only place that could use qualified schema and relation. If you
>> search for get_namespace_name_or_temp you will notice that this code path is
>> repeated in other parts of the code too (see ruleutils.c). It would be good if
>> we can have a common path for it. Maybe the signature has to be
>> get_qualified_relname(Oid) to accommodate
>
>
> IMHO it’s not a good idea to use Oid when you already have reldesc.

+1.

I looked at other use cases of get_namespace_name_or_temp(), and there
doesn’t seem to be any case where we already have a Relation
descriptor. So this appears to be a unique scenario, and I feel adding
a new function here makes sense. If needed, ruleutils.c’s
generate_qualified_relation_name() could be moved to a common location
in a separate patch.

Thanks,
Shveta

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-05-04 05:41:32 Add heap and index vacuum timings to pg_stat_progress_vacuum
Previous Message shveta malik 2026-05-04 05:08:10 Re: Fix race condition in pg_get_publication_tables with concurrent DROP TABLE