Re: Column does not exists?

El 26/03/15 a las 14:23, Francisco Olarte escibió:
> Hi Leonardo:
>
> On Thu, Mar 26, 2015 at 6:12 PM, "Leonardo M. Ramé" <l(dot)rame(at)griensu(dot)com> wrote:
>> DELETE From sessions WHERE SESSIONTIMESTAMP < '2010-01-01 10:02:02'
>> ERROR: column "sessiontimestamp" does not exist
>> LINE 1: DELETE From sessions WHERE SESSIONTIMESTAMP < '2010-01-01 10...
> ...
>> DELETE From sessions WHERE "SESSIONTIMESTAMP" < '2010-01-01 10:02:02'
>>
>> It DOES work.
>>
>> Why the db doesn't recognize the name of the table without quotes?.
>
> Unquoted identifiers for several things, column names amongst them,
> are treated by case folding in SQL. Many DBs do it to uppercase,
> postgres does it to lower case ( as hinted by the column name being
> printed in lowercase ). So if you QUOTE an UPPERCASE name you must
> quote it always.
>
> As a rule of thumb, I'll recommend quoting your identifiers always or
> never, quoting it in some statements ( create ) and not others ( 1st
> delete ) will normally surprise you on unpleasant ways.
>
> Francisco Olarte.
>

Aha, the problem, then, was caused by the Create statement. This table
was copied from a MySql dump where all columns were named "column".