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

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: "field doesn't exist" even though I'm sure it does
Дата
Msg-id 20071116202421.GB1955@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответ на "field doesn't exist" even though I'm sure it does  (Tom Hart <tomhart@coopfed.org>)
Ответы Re: "field doesn't exist" even though I'm sure it does
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: "field doesn't exist" even though I'm sure it does
Следующее
От: Tom Hart
Дата:
Сообщение: Re: "field doesn't exist" even though I'm sure it does