Skip site navigation (1) Skip section navigation (2)

Re: column doesnt exist?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Cao Duy <cao(dot)duy(at)1und1(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: column doesnt exist?
Date: 2004-11-18 15:06:33
Message-ID: 20041118070522.I74969@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, 18 Nov 2004, Cao Duy wrote:

> 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

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.


In response to

pgsql-bugs by date

Next:From: Michael FuhrDate: 2004-11-18 15:22:45
Subject: Re: column doesnt exist?
Previous:From: Cao DuyDate: 2004-11-18 14:47:16
Subject: column doesnt exist?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group