0

ULID Base32 01GMEX2SA207FNV8E19QM8EJ4M is the same as RFC4122 01851dd1-6542-01df-5da1-c14de8874894.

Postgresql appears to store the ULIDs in RFC4122 format.

Both GET /assets/01GMEX2SA207FNV8E19QM8EJ4M/resource_acl and GET /assets/01851dd1-6542-01df-5da1-c14de8874894/resource_acl return the same successful response:

{
  "id": "/assets/01GMEX2SA207FNV8E19QM8EJ4M/resource_acl",
  "asset": "/assets/01GMEX2SA207FNV8E19QM8EJ4M",
  "members": [
    "/resource_acl_members/acl=01GMEX2SA207FNV8E19QM8EJ4M;user=01GMEX2SA1FEZHVQJYTW48P7FE"
  ]
}

GET /resource_acl_members/acl=01851dd1-6542-01df-5da1-c14de8874894;user=01851dd1-6541-7bbf-1dde-5ed7088b1dee returns the desired successful response.

{
  "id": "/resource_acl_members/acl=01GMEX2SA207FNV8E19QM8EJ4M;user=01GMEX2SA1FEZHVQJYTW48P7FE",
  "acl": "/assets/01GMEX2SA207FNV8E19QM8EJ4M/resource_acl",
  "user": "/tenant_users/01GMEX2SA1FEZHVQJYTW48P7FE",
  "roles": [
    "ROLE_MANAGE_PROJECT"
  ]
}

GET /resource_acl_members/acl=01GMEX2SA207FNV8E19QM8EJ4M;user=01GMEX2SA1FEZHVQJYTW48P7FE, however, returns Postgresql error: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: \"01GMEX2SA207FNV8E19QM8EJ4M\"\nCONTEXT: unnamed portal parameter $1 = '...'",.

Should I be consistent and use either solely Base32 or RFC4122? If so, which format?

user1032531
  • 24,767
  • 68
  • 217
  • 387

0 Answers0