Обсуждение: pgsql: Catch syntax error in generated column definition

Поиск
Список
Период
Сортировка

pgsql: Catch syntax error in generated column definition

От
Peter Eisentraut
Дата:
Catch syntax error in generated column definition

The syntax

    GENERATED BY DEFAULT AS (expr)

is not allowed but we have to accept it in the grammar to avoid
shift/reduce conflicts because of the similar syntax for identity
columns.  The existing code just ignored this, incorrectly.  Add an
explicit error check and a bespoke error message.

Reported-by: Justin Pryzby <pryzby@telsasoft.com>

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7241911782a7420e38b6e50b57d304ea48bc5362

Modified Files
--------------
src/backend/parser/gram.y               | 13 +++++++++++++
src/test/regress/expected/generated.out |  5 +++++
src/test/regress/sql/generated.sql      |  3 +++
3 files changed, 21 insertions(+)