Limitations v5

The following limitations apply to MongoDB Foreign Data Wrapper:

  • If the BSON document key contains uppercase letters or occurs in a nested document, MongoDB Foreign Data Wrapper requires the corresponding column names to be declared in double quotes.
  • PostgreSQL limits column names to 63 characters by default. You can increase the NAMEDATALEN constant in src/include/pg_config_manual.h, compile, and reinstall when column names exceed 63 characters.
  • MongoDB Foreign Data Wrapper returns an error on BSON field that isn't listed in the known types (for example, byte, arrays). It returns this error: Cannot convert BSON type to column type.