Re: column doesnt exist?

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

> 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

Since you prefer case sensitive col names, try

 select "AbfrageTyp" from stresslog

>
> 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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

--
-Achilleus