citusdata / citusdata/citus

Our errors for function evaluation can be difficult to understand

Open
#1,384 0 comments 2 reactions 0 assignees View on GitHub
usability
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

**Motivation**

In [this ticket](https://github.com/citusdata/citus/issues/1380) a user was given the error

`ERROR: STABLE functions used in UPDATE queries cannot be called with column references`

while trying to run

```
SELECT master_modify_multiple_shards('UPDATE geonames.geonames
SET geometry = ST_PointFromText(''POINT('' || longitude || '' '' || latitude || '')''
');
```

and quite reasonably wondered which function was `STABLE`. Since implicit casts are often `STABLE` this feels like it could be a common problem.

**Proposal**

We should add a `HINT` which names the offending function.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.