column doesnt exist?
От | Cao Duy |
---|---|
Тема | column doesnt exist? |
Дата | |
Msg-id | 1100789236.10058.13.camel@Knoppix обсуждение исходный текст |
Ответы |
Re: column doesnt exist?
Re: column doesnt exist? Re: column doesnt exist? |
Список | 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
В списке pgsql-bugs по дате отправления: