CAP CDS 7.x Postgres and odata

[LuizGomes]

cds -v

@cap-js/db-service: 1.0.1
@cap-js/postgres: 1.0.1
@sap/cds: 7.0.2
@sap/cds-compiler: 4.0.2
@sap/cds-dk (global): 7.0.2
@sap/cds-fiori: 1.0.0
@sap/cds-foss: 4.0.2
@sap/cds-mtxs: 1.9.0
@sap/cds-odata-v2-adapter-proxy: 1.9.21
@sap/eslint-plugin-cds: 2.6.3
Node.js: v18.16.0
home: /workspace/node_modules/@sap/cds

docker-compose.yml

 db:
    image: postgres
    restart: unless-stopped
    volumes:
      - postgres-data:/var/lib/postgresql/data
    environment:
      POSTGRES_PASSWORD: postgres
      POSTGRES_USER: postgres
      POSTGRES_DB: postgres

error on get endpoint

Has anyone ever experienced this? is it a cds cap bug? is there any configuration missing in postgres?

[Willem_Pardaens]

Hi Luis, the 'pt' refers to the Portuguese language that is configured. Make sure that the postgres database is using a supported language. This might help: https://stackoverflow.com/questions/54182795/error-trying-to-create-a-database-with-utf-8-encoding-a...