Re: "field doesn't exist" even though I'm sure it does

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "field doesn't exist" even though I'm sure it does
Date: 2007-11-16 20:24:21
Message-ID: 20071116202421.GB1955@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 16, 2007 at 03:13:48PM -0500, Tom Hart wrote:
> column "isactive" of relation "membermailingaddress" does not exist
>
> Table "public.membermailingaddress"
> Column | Type | Modifiers
> -----------------+--------------+-----------
> IsActive | boolean |

If you don't enclose an identifier in double quotes (") then PG will
make the identifier lowercase before looking for it. This is in an
attempt to support case-insensitive general usage, while still allowing
case-sensitive usage if you really want it.

Sam

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Hart 2007-11-16 20:25:30 Re: "field doesn't exist" even though I'm sure it does
Previous Message Sam Mason 2007-11-16 20:21:20 Re: Primary Key