Request a Demo
Home   >   mailing lists

[bug] keyword commit being accepted for column name - Mailing list pgsql-bugs

From Vinícius Abrahão
Subject [bug] keyword commit being accepted for column name
Date
Msg-id CAM9Bftxfy7KJzk8tp6kCMz7+sA0vpfaOBsk2_pSfuMMoVwW4Rw@mail.gmail.com
Whole thread
Responses Re: [bug] keyword commit being accepted for column name
Re: [bug] keyword commit being accepted for column name
List pgsql-bugs
Tree view
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

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Logical replication 'invalid memory alloc request size 1585837200' after upgrading to 17.5
Next
From: Kirk Parker
Date:
Subject: Re: [bug] keyword commit being accepted for column name