SAP Knowledge Base Article - Preview

3673659 - Error: Access method 'brin'/'gin' does not support ASC/DESC options in PostgreSQL - SAP PD

Symptom

  • The PostgreSQL DBMS Resource file (XDB) has been customized to include BRIN and GIN index types.
  • Creating an index using either BRIN or GIN types, the sorting order ASC or DESC is specified for columns.
  • When executing the SQL script, the following error messages are returned:
     - BRIN indexes: ERROR: access method 'brin' does not support ASC/DESC options
     - GIN indexes: ERROR: access method 'gin' does not support ASC/DESC options.


Read more...

Environment

  • SAP PowerDesigner (PD) 16.7
  • PostgreSQL 14.x, 16.x

Product

SAP PowerDesigner 16.7

Keywords

postgresql, psql, gin, brin, index, asc, desc, sorting, order, CR831384, CR#831384, 831384 , KBA , BC-SYB-PD , PowerDesigner , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.