Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog
Date: 2024-04-09 17:09:35
Message-ID: 3757728.1712682575@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> On 4/9/24 08:12, Thiemo Kellner wrote:
>>> PG_CATALOG.PG_ROLES.ROLNAME := 'snowrunner_reader';
>>>
>>> Is being seen as DB_NAME.TABLE_NAME.COLUMN_NAME.

No, it's being seen as DB_NAME.SCHEMA_NAME.TYPE_NAME.

> Because you did not do?:
> PG_CATALOG.PG_ROLES.ROLNAME%type

Exactly. The %type bit is important.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2024-04-09 17:10:38 Re: PL/pgSQL techniques better than bash for dynamic DO?
Previous Message Tom Lane 2024-04-09 17:03:28 Re: Issue with date/timezone conversion function