| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | 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 15:18:48 |
| Message-ID: | 2b633b1d-8dbe-4a3e-9d0c-f28628357799@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/9/24 08:12, Thiemo Kellner wrote:
> Thanks for taking this up.
>
> Am 09.04.2024 um 17:09 schrieb Adrian Klaver:
>> On 4/9/24 07:59, Thiemo Kellner wrote:
>> [Code: 0, SQL State: 0A000] ERROR: References to other databases are
>> not implemented: pg_catalog.pg_roles.rolname
>> Position: 298 [Script position: 334 - 361]
>>
>> PG_CATALOG.PG_ROLES.ROLNAME := 'snowrunner_reader';
>>
>> Is being seen as DB_NAME.TABLE_NAME.COLUMN_NAME.
>
> Yes, obviously, but why? With the information_schema view all is fine.
> And, I suppose, with all other objects in other schemas of the same
> database too.
Because you did not do?:
PG_CATALOG.PG_ROLES.ROLNAME%type
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastien Flaesch | 2024-04-09 15:32:29 | Re: Tracing libpq client: Only with PQtrace()? |
| Previous Message | Thiemo Kellner | 2024-04-09 15:12:02 | Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog |