[bug] keyword commit being accepted for column name

From: Vinícius Abrahão <vinnix(dot)bsd(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: [bug] keyword commit being accepted for column name
Date: 2025-05-31 18:03:09
Message-ID: CAM9Bftxfy7KJzk8tp6kCMz7+sA0vpfaOBsk2_pSfuMMoVwW4Rw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kirk Parker 2025-05-31 18:22:08 Re: [bug] keyword commit being accepted for column name
Previous Message vignesh C 2025-05-31 07:57:52 Re: Logical replication 'invalid memory alloc request size 1585837200' after upgrading to 17.5