Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog
| От | Adrian Klaver |
|---|---|
| Тема | Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog |
| Дата | |
| Msg-id | 2b633b1d-8dbe-4a3e-9d0c-f28628357799@aklaver.com обсуждение исходный текст |
| Ответ на | Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog (Thiemo Kellner <thiemo@gelassene-pferde.biz>) |
| Ответы |
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog |
| Список | 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.klaver@aklaver.com
В списке pgsql-general по дате отправления: