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

BUG #3430: Case Sensitive Table Names

From: "Ashwin" <ashwin_poddar(at)persistent(dot)co(dot)in>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3430: Case Sensitive Table Names
Date: 2007-07-06 07:08:57
Message-ID: 200707060708.l6678vgL060512@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3430
Logged by:          Ashwin
Email address:      ashwin_poddar(at)persistent(dot)co(dot)in
PostgreSQL version: 8.2.4
Operating system:   Linux
Description:        Case Sensitive Table Names
Details: 

I have a strange problem,

I have created a Table with name Employee_Master
when i fire a  Query as 
Select * from Employee_Master 
it give me an error as employee_master doesnt Exists.
but when i rename my table name as employee_master
the query works fine...
is that necessary to have table names in small case????
Please help me...


Thanks,
Ashwin

Responses

pgsql-bugs by date

Next:From: Stéphane SchildknechtDate: 2007-07-06 07:38:44
Subject: Re: BUG #3430: Case Sensitive Table Names
Previous:From: balajisundarDate: 2007-07-06 06:58:59
Subject: DB Install Problem

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