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  (Neil Conway <neilc@samurai.com>)
Список 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 по дате отправления:

Предыдущее
От: Vincent Vanwynsberghe
Дата:
Сообщение: Re: [PORTS] Bug Report with Postgres 7.4 on AIX 5.3
Следующее
От: "Dimitar"
Дата:
Сообщение: BUG #1675: very slow work