8000 OBS_GetMetadata raises a "null values cannot be formatted as an SQL identifier" · Issue #220 · CartoDB/observatory-extension · GitHub
[go: up one dir, main page]

Skip to content
OBS_GetMetadata raises a "null values cannot be formatted as an SQL identifier"  #220
@rafatower

Description

@rafatower

Some queries to OBS_GetMetadata fail because of a ERROR: null values cannot be formatted as an SQL identifier exception.

removed traceback

The problem is located around these lines:
https://github.com/CartoDB/observatory-extension/blob/develop/src/pg/sql/41_observatory_augmentation.sql#L468

In general that exception will be raised for any such instance of this construction:

format('%I', some_null_value)

I'll post more information to debug the issue as soon as we get it. We cannot get more information yet because of the segmentation fault, which will be solved with this patch: CartoDB/postgres#4

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0