hi,

I created this table:
CREATE TABLE public.stresslog(
"AbfrageId" int8 NOT NULL DEFAULT
nextval('public."stresslog_AbfrageId_seq"'::text),
"AbfrageTyp" varchar(50) NOT NULL,
"Abfrage" varchar(300),
"AnzZeilen" int8 DEFAULT 0,
"ZeitVerbrauch" int8 DEFAULT 0,
"AnzCon" int4 DEFAULT 0,
"AnzSchreib" int4 DEFAULT 0,
"AnzLesen" int4 DEFAULT 0,
"AnzTabDs" int8 DEFAULT 0,
"TabName" varchar(100),
"AnzAnweisungen" int4 DEFAULT 1,
"SystemMeldung" varchar(100) DEFAULT 'OK'::character varying,
"AusfuehrungsZeit" date,
CONSTRAINT stresslog_pkey PRIMARY KEY ("AbfrageId")
) WITHOUT OIDS;

I try to execute the following statement and get this err.msg:
select AbfrageTyp from stresslog
->ERROR: Column abfragetyp doesn't exist

the same err.msg occurs to all other field ... that mean query like
"select TabName,Anzcon from stresslog" doesn't work.

I try SELECT * FROM STRESSLOG, that works fine.
what's wrong? It is a (known) bug?


please help


best regards


ps: enviroments: pgSQL 7.4.3 on SunOS


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Thu, 18 Nov 2004, Cao Duy wrote:

Unquoted column names are casefolded (in PostgreSQL to lowercase, in
standard SQL to uppercase). You need to say select "AbfrageTyp" from
stresslog if you create the table with double quoted column names.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

O Cao Duy Ýãñáøå óôéò Nov 18, 2004 :

Since you prefer case sensitive col names, try

select "AbfrageTyp" from stresslog

--
-Achilleus


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Thu, Nov 18, 2004 at 03:47:16PM +0100, Cao Duy wrote:

[snip]

Read the "Identifiers and Key Words" section of the "SQL Syntax"
chapter in the documentation, especially the parts about quoted
identifiers.

http://www.postgresql.org/docs/7.4/s...AX-IDENTIFIERS

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html