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

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: Mixing quoted mixed case column names and non quoted constraints definitions in CREATE TABLE causes an error
Дата
Msg-id 23472721549224132@iva8-cf3e488a465f.qloud-c.yandex.net
обсуждение исходный текст
Ответ на Mixing quoted mixed case column names and non quoted constraintsdefinitions in CREATE TABLE causes an error  (Rusty Conover <rusty@conover.me>)
Список 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
fromthese three and each other.
 

regards, Sergei

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Rusty Conover
Дата:
Сообщение: Mixing quoted mixed case column names and non quoted constraintsdefinitions in CREATE TABLE causes an error
Следующее
От: "Saul, Jean Paolo"
Дата:
Сообщение: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes