[bug?] oddity creating table with uppercase initial

Поиск
Список
Период
Сортировка
От Paul Makepeace
Тема [bug?] oddity creating table with uppercase initial
Дата
Msg-id 20030602220724.GG6093@mythix.realprogrammers.com
обсуждение исходный текст
Ответы Re: [bug?] oddity creating table with uppercase initial  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: [bug?] oddity creating table with uppercase initial  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-novice
[psql (PostgreSQL) 7.2.1 and 7.3.2 on Debian testing]

Creating a table "Banks" succeeds but then appears not to exist. It does
however show in a \d listing, but won't autocomplete(!) i.e. \d Ba<tab>

On a newly created db,

=> create sequence Banks_id_seq;
CREATE
=> CREATE TABLE "Banks" ("id" integer DEFAULT nextval('"Banks_id_seq"'::text) NOT NULL);
CREATE
=> select * from banks;
ERROR:  Relation "banks" does not exist
=> select * from Banks;
ERROR:  Relation "banks" does not exist
=> CREATE TABLE "banks" ("id" integer DEFAULT nextval('"Banks_id_seq"'::text) NOT NULL);
CREATE
=> \d
         List of relations
     Name     |   Type   |  Owner
--------------+----------+----------
 Banks        | table    | ...
 banks        | table    | ...
 banks_id_seq | sequence | ...
(3 rows)

(The 7.3.2 appears to behave identically except with its listing of the
schema being public in \d)

Should I simply avoid names with uppercase? This seems like a shame.

Paul

--
Paul Makepeace ....................................... http://paulm.com/

"What is a quigibo? A yeast infection gone wrong."
   -- http://paulm.com/toys/surrealism/


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

Предыдущее
От: Thiemo Kellner
Дата:
Сообщение: Re: Updatable view does not work [oops, quite long!]
Следующее
От: Joanne Formoso
Дата:
Сообщение: Strange Encryption Bug