Re: [BUGS] BUG #2648: I can not create table name with capital and

#1

Asaf,

quote them and it will work.

Richard

On Sun, 24 Sep 2006, Asaf Avraham wrote:

Quote:

Date: Sun, 24 Sep 2006 06:18:38 GMT
From: Asaf Avraham <asaf.avraham (AT) gmail (DOT) com
To: pgsql-bugs (AT) postgresql (DOT) org
Subject: [BUGS] BUG #2648: I can not create table name with capital and
small characters

The following bug has been logged online:

Bug reference: 2648
Logged by: Asaf Avraham
Email address: asaf.avraham (AT) gmail (DOT) com
PostgreSQL version: 8.1.4.2
Operating system: win
Description: I can not create table name with capital and small
characters
Details:

I have table that contain name with capital and small characters (ex.
tblEmp). In the columns is the same (ex. EmpID).

In Creating table postgres add inverted commas on the name

When I'm running any query on this table i get:
1. select * from tblEmp
Get: ERROR: relation "tblemp" does not exist
2. select * from "tblEmp"
Get: Resulted

Thanks

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy (AT) ScienceTools (DOT) com, http://ScienceTools.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2648: I can not create table name with capital and

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2648: I can not create table name with capital and - 09-24-2006 , 04:59 PM