Adrian Klaver 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
Ex
Am 09.04.2024 um 17:18 schrieb Adrian Klaver:
Because you did not do?:
PG_CATALOG.PG_ROLES.ROLNAME%type
Thanks
Am 09.04.2024 um 17:18 schrieb Adrian Klaver:
Because you did not do?:
PG_CATALOG.PG_ROLES.ROLNAME%type
Oh, right. Sorry. What an oversight.
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 po
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.
On 4/9/24 07:59, Thiemo Kellner wrote:
Hi
I have the following function code. When trying to install, it gives me
[Code: 0, SQL State: 0A000] FEHLER: Verweise auf andere Datenbanken
sind nicht implementiert: pg_catalog.pg_roles.rolname
Position: 298 [Script position: 334 - 361]
[Code:
Hi
I have the following function code. When trying to install, it gives me
[Code: 0, SQL State: 0A000] FEHLER: Verweise auf andere Datenbanken
sind nicht implementiert: pg_catalog.pg_roles.rolname
Position: 298 [Script position: 334 - 361]
To the best of my knowledge, pg_catalog is a sche