Re: first message: SELECT <column> FROM <t

On Feb 2, 2008, at 6:56 PM, Bill Moran wrote:

> preserved that. PostgreSQL is case-sensative, so try matching the
> column
> name exactly and putting "" around it. If that doesn't work,
> provide some

That is just plain incorrect, PostgreSQL is *not* case sensitive. The
real problem here (as Scott pointed out) is that the column in the
table is defined so that the case is preserved (by quoting the column
name), but the column in the query isn't and thus gets folded (to
lowercase) and can't be found.

I'm inclined to call this a bug in PgAdmin III (except that I hardly
know it), it shouldn't quote identifiers to keep case if the user
doesn't explicitly ask it to. This question pops up frequently, so it
would be nice if something was done about it (my preference would be
by not /implicitly/ quote identifiers). It certainly seems to confuse
novice users.

My €0.02.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.

!DSPAM:737,47a4c3e7817485094119420!