BUG #5749: Case sensivity of names of sequences.
От | Denis |
---|---|
Тема | BUG #5749: Case sensivity of names of sequences. |
Дата | |
Msg-id | 201011111526.oABFQ8ku098840@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5749: Case sensivity of names of sequences.
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5749 Logged by: Denis Email address: DolgalevDenis@mail.ru PostgreSQL version: 9.0.1 Operating system: Windows XP Description: Case sensivity of names of sequences. Details: Hello. I found some problem with sequences names. I am new in Postgresql, so sorry if this problem was already discussed. I wanted to make a simple table with ID column, that value must be taken from the sequence (automatically incremented by 1 in every next record). 1. In GUI I created the sequence with name âNameSeqâ (uppercase âNâ and âSâ). 2. Then I was trying to create a table using this simple querry: CREATE TABLE "Names" ( "NameId" bigint NOT NULL DEFAULT nextval('NameSeq') primary key, "Name" char(20), "FirstName" char(30), "SecondName" char(30) ) WITH ( OIDS = FALSE ) ; But I get the error: âERROR: relation "nameseq" does not exist SQL state: 42P01â As you can see, sequence name in error message written in lowercase, but in querry I used âNameSeqâ. 3. I created new sequence ânameseqâ (ânâ and âsâ in lowercase) and the querry was completed without errors. Should the sequence names always be in lowercase or it`s a bug?
В списке pgsql-bugs по дате отправления: