gistfile1.sql

WITH role_oids AS (
  INSERT INTO pg_authid SELECT concat('Role', id), false, false, false, false, false, true, false, -1, md5(id::text), NULL FROM person RETURNING oid
)
INSERT INTO pg_auth_members
  SELECT
    (SELECT oid FROM pg_authid WHERE rolname = 'enduser'),
    role_oids,
    10,
    false
    FROM role_oids;


ERROR:  column "member" is of type oid but expression is of type record
ZEILE 7:     role_oids,
             ^
TIP:  You will need to rewrite or cast the expression.

********** Fehler **********

ERROR: column "member" is of type oid but expression is of type record
SQL Status:42804
Hinweis:You will need to rewrite or cast the expression.
Zeichen:272