Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ICU not supported #19

Open
egasimus opened this issue Dec 3, 2024 · 0 comments
Open

ICU not supported #19

egasimus opened this issue Dec 3, 2024 · 0 comments

Comments

@egasimus
Copy link

egasimus commented Dec 3, 2024

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/[email protected]/node_modules/pg-protocol/dist/parser.js:283:98)
      at Parser.handlePacket (/home/user/project/node_modules/.pnpm/[email protected]/node_modules/pg-protocol/dist/parser.js:122:29)
      at Parser.parse (/home/user/project/node_modules/.pnpm/[email protected]/node_modules/pg-protocol/dist/parser.js:35:38)
      at Socket.<anonymous> (/home/user/project/node_modules/.pnpm/[email protected]/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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant