From: Patrick JACQUOT <patrick.jacquot@anpe.fr>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: some error when executing query in pgAdmin tool
Date: Tue, 23 May 2006 14:38:51 +0200
Message-ID: <4473025B.2070904@anpe.fr> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C90645C7A1@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C90645C7A1@venus.infics.com>
Penchalaiah P. wrote:
> I created one table in pgAdmin tool but when I am executing query it
> is giving error….
>
> CREATE TABLE "ADV"
>
> (
>
> "T-Section_Id" varchar(10) NOT NULL,
>
> "CDA_No" varchar(7) NOT NULL,
>
> "Imp_Schedule_Id" int4 NOT NULL,
>
> "Sanction_No" varchar(20) NOT NULL,
>
> "Sanction_Date" date NOT NULL,
>
> "Station_From" varchar(20) NOT NULL,
>
> "Station_To" varchar(20) NOT NULL,
>
> "Amt_Claimed" int4,
>
> "Amt_Admitted" int4,
>
> "Dak_Id" varchar(20) NOT NULL,
>
> "Refund_Dak_Id" int4 NOT NULL,
>
> "T-Wing_Allowance_Id" varchar(10) NOT NULL,
>
> CONSTRAINT "ADV_pkey" PRIMARY KEY ("T-Section_Id")
>
> )
>
> WITHOUT OIDS;
>
> ALTER TABLE "ADV" OWNER TO postgres;
>
> Above table I created…..
>
> Select * from ADV; when I am executing this query I am getting error is
>
> Relation ADV does not exist… like this error is giving … may I know y
> am I getting this error
>
> *Thanks & Regards*
>
> *Penchal reddy **|** Software Engineer *
>
> *Infinite Computer Solutions **|** Exciting Times…Infinite
> Possibilities... *
>
> *SEI-CMMI level 5 **| **ISO 9001:2000*
>
> *IT SERVICES **|** BPO *
>
> *Telecom **|** **Finance **|** **Healthcare **| **Manufacturing **|**
> **Energy & Utilities **|** **Retail & Distribution **|** **Government *
>
> *Tel +91-80-5193-0000(Ext:503)**|** Fax +91-80-51930009 **|** Cell No
> +91-9980012376**|**www.infics.com** *
>
> *Information transmitted by this e-mail is proprietary to Infinite
> Computer Solutions and/ or its Customers and is intended for use only
> by the individual or entity to which it is addressed, and may contain
> information that is privileged, confidential or exempt from disclosure
> under applicable law. If you are not the intended recipient or it
> appears that this mail has been forwarded to you without proper
> authority, you are notified that any use or dissemination of this
> information in any manner is strictly prohibited. In such cases,
> please notify us immediately at** **_info.in@infics.com _**and delete
> this mail from your records.*
>
by quoting ADV in the CREATE TABLE you made it case-sensitive
then by not quoting it in the SELECT, you used the case-insensitive form,
wich PostgreSQL (IIRC) translates as lower case
adv != ADV
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: patrick.jacquot@anpe.fr, penchalaiahp@infics.com
Subject: Re: some error when executing query in pgAdmin tool
In-Reply-To: <4473025B.2070904@anpe.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox