Re: Mixing quoted mixed case column names and non quoted constraints definitions in CREATE TABLE causes an error

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Rusty Conover <rusty(at)conover(dot)me>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Mixing quoted mixed case column names and non quoted constraints definitions in CREATE TABLE causes an error
Date: 2019-02-03 20:02:12
Message-ID: 23472721549224132@iva8-cf3e488a465f.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello

This is expected and documented behavior: https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

> Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case. For example, the identifiers FOO, foo, and "foo" are considered the same by PostgreSQL, but "Foo" and "FOO" are different from these three and each other.

regards, Sergei

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Saul, Jean Paolo 2019-02-03 22:45:12 Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes
Previous Message Rusty Conover 2019-02-03 19:03:55 Mixing quoted mixed case column names and non quoted constraints definitions in CREATE TABLE causes an error