BUG #1674: CREATE TABLE "name" (with double quotes) and resulting behavior

Поиск
Список
Период
Сортировка
От Herman Bos
Тема BUG #1674: CREATE TABLE "name" (with double quotes) and resulting behavior
Дата
Msg-id 20050519122131.548D6F0B14@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1674: CREATE TABLE "name" (with double quotes) and
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1674
Logged by:          Herman Bos
Email address:      hbos@osso.nl
PostgreSQL version: 7.4.7
Operating system:   Ubuntu Linux 5.04
Description:        CREATE TABLE "name" (with double quotes) and resulting
behavior
Details:

for the create table in question:
http://users.lichtsnel.nl/~spacey/school/vib/vib.sql
entered into the database like this:
psql -d vib -U vib < vib.sql

results on my system
vib=> \d
         List of relations
 Schema |   Name   | Type  | Owner
--------+----------+-------+-------
 public | SANCTIES | table | vib
(1 row)

vib=> select * from SANCTIES;
ERROR:  relation "sancties" does not exist
vib=> \d SANCTIES
Did not find any relation named "SANCTIES".


After realizing that it occurred after putting the tablename between double
qoutes. The same behavior happend with the column names.

vib=> select * from "bedrag";
ERROR:  relation "bedrag" does not exist
vib=> select bedrag from sancties;
ERROR:  column "bedrag" does not exist
vib=> select "bedrag" from sancties;
ERROR:  column "bedrag" does not exist
vib=> select "BEDRAG" from sancties;
 BEDRAG
--------
(0 rows)

I was wondering if this behavior is correct. According to my local
postgresql poweruser its a bug.

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