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