Skip to content

ICU not supported #19

@egasimus

Description

@egasimus

We have this statement as part of our DB provisioning (in order to enable sorting numeric strings as numbers):

CREATE COLLATION IF NOT EXISTS numeric (provider = icu, locale = 'en-u-kn-true')

It throws the following error:

error: ICU is not supported in this build
      at Parser.parseErrorMessage (/home/user/project/node_modules/.pnpm/pg-protocol@1.6.1/node_modules/pg-protocol/dist/parser.js:283:98)
      at Parser.handlePacket (/home/user/project/node_modules/.pnpm/pg-protocol@1.6.1/node_modules/pg-protocol/dist/parser.js:122:29)
      at Parser.parse (/home/user/project/node_modules/.pnpm/pg-protocol@1.6.1/node_modules/pg-protocol/dist/parser.js:35:38)
      at Socket.<anonymous> (/home/user/project/node_modules/.pnpm/pg-protocol@1.6.1/node_modules/pg-protocol/dist/index.js:11:42)
      at Socket.emit (node:events:519:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5)
      at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
    length: 160,
    severity: 'ERROR',
    code: '0A000',
    detail: undefined,
    hint: 'You need to rebuild PostgreSQL using --with-icu.',
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'pg_locale.c',
    line: '1586',
    routine: 'pg_newlocale_from_collation',
    sql: "CREATE COLLATION IF NOT EXISTS numeric (provider = icu, locale = 'en-u-kn-true')",
    parameters: undefined
  }

Is building pgmock with the --with-icu flag possible?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions