[bug] keyword commit being accepted for column name
Vinícius Abrahão <vinnix.bsd@gmail.com>
From: Vinícius Abrahão <vinnix.bsd@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Date: 2025-05-31T18:03:09Z
Lists: pgsql-bugs
postgres=# create table postgres_git_repository(commit text,
first_line_commit text);
CREATE TABLE
postgres=# create table postgres_git_repository2("commit" text,
first_line_commit text);
CREATE TABLE
postgres=# create table postgres_git_repository3("COMMIT" text,
first_line_commit text);
CREATE TABLE
postgres=# select version();
version
--------------------------------------------------------------------------------------------------------
PostgreSQL 17.4 on x86_64-pc-linux-gnu, compiled by clang version 19.1.7
(CentOS 19.1.7-1.el9), 64-bit
postgres=# \d postgres_git_repository
Table "public.postgres_git_repository"
Column | Type | Collation | Nullable | Default
-------------------+------+-----------+----------+---------
commit | text | | |
first_line_commit | text | | |
postgres=# \h commit
Command: COMMIT
Description: commit the current transaction
Syntax:
COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
URL: https://www.postgresql.org/docs/17/sql-commit.html