column doesnt exist?

From: Cao Duy <cao(dot)duy(at)1und1(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: column doesnt exist?
Date: 2004-11-18 14:47:16
Message-ID: 1100789236.10058.13.camel@Knoppix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2004-11-18 15:06:33 Re: column doesnt exist?
Previous Message Stephan Szabo 2004-11-18 14:18:44 Re: BUG #1325: like error