pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
(no subject)
2+ messages / 2 participants
[nested] [flat]

* (no subject)
@ 2000-11-20 03:24  Sean Weissensee <sweiss@ionsol.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: Sean Weissensee @ 2000-11-20 03:24 UTC (permalink / raw)
  To: pgsql-sql

Why does this error come up

 ionsol=> update quickstock set ItemDesc = '10000',Qty = 0.0,salesprice = 0
.0 where StockID = '8597' \g
ERROR:  Relation 'quickstock' does not have attribute 'itemdesc'   

when ItemDesc does exist.

Sean

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re:
@ 2000-11-23 20:49  Ross J. Reedstrom <reedstrm@rice.edu>
  parent: Sean Weissensee <sweiss@ionsol.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Ross J. Reedstrom @ 2000-11-23 20:49 UTC (permalink / raw)
  To: Sean Weissensee <sweiss@ionsol.com.au>; +Cc: pgsql-sql

On Mon, Nov 20, 2000 at 01:24:32PM +1000, Sean Weissensee wrote:
> Why does this error come up
> 
>  ionsol=> update quickstock set ItemDesc = '10000',Qty = 0.0,salesprice = 0
> .0 where StockID = '8597' \g
> ERROR:  Relation 'quickstock' does not have attribute 'itemdesc'   
> 
> when ItemDesc does exist.


Because SQL is case insensitive, by default. Postgresql implements this by
downcasing all identifiers (table and column names) unless quoted with
double quotes. I'm guessing that you created this table via MS-Access. The
ODBC driver quotes identifiers by default.

Try this:

update quickstock set "ItemDesc" = '10000',"Qty" = 0.0,salesprice =
0.0 where "StockID" = '8597' \g

Ross
-- 
Open source code is like a natural resource, it's the result of providing
food and sunshine to programmers, and then staying out of their way.
[...] [It] is not going away because it has utility for both the developers 
and users independent of economic motivations.  Jim Flynn, Sunnyvale, Calif.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-11-23 20:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-20 03:24  Sean Weissensee <sweiss@ionsol.com.au>
2000-11-23 20:49 ` Re: Ross J. Reedstrom <reedstrm@rice.edu>

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