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

Re: BUG #2501: JOIN and capitial letters in Table Row

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: ALL <thegreatall(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2501: JOIN and capitial letters in Table Row
Date: 2006-06-28 15:38:24
Message-ID: 20060628153824.GZ44573@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-bugs
If you define an object using quotes to preserve case, you must always
refer to that object with quotes, ie: productoptions."ProductID".

My recommendation: use underscores in the database
(product_options.product_id). Personally, I wouldn't pluralize the
table names either, but that's just me...

On Wed, Jun 28, 2006 at 03:13:28AM +0000, ALL wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      2501
> Logged by:          ALL
> Email address:      thegreatall(at)gmail(dot)com
> PostgreSQL version: 8.1
> Operating system:   Windows
> Description:        JOIN and capitial letters in Table Row
> Details: 
> 
> I had a table as like the following named products:
> 
> id	ClientID	ProductID	is_multiqty	is_active
> 1	12345	1000001	1	1
> 2	12345	1000002	0	1
> 
> and another table named productoptions with the following:
> 
> id	ProductID	Sku	Description	OptionID	minpayments	maxpayments	maxqty	is_acti
> ve
> 1	1000001	somedesc1	1	1	1	0	1
> 1	1000002	CX7535	somedesc2	1	1	3	0	1
> 
> when I ran the following sql I got: ""ERROR:  column product.ProductID does
> not exist":
> 
> SELECT *
> FROM products
> JOIN productoptions
> ON products.ProductID = productoptions.ProductID
> 
> However, if i changed the name of the fields in the database to:
> 
> "productid"
> 
> It would work fine.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-06-28 15:39:47
Subject: Re: BUG #2494: SCROLL CURSOR does not worl
Previous:From: Jim C. NasbyDate: 2006-06-28 15:35:50
Subject: Re: [BUGS] BUG #2500: subscribing for digest

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