Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"

Поиск
Список
Период
Сортировка
От Juris
Тема Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Дата
Msg-id 4f31e3850601192252md973d4fs@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"  (Michael Glaesemann <grzm@myrealbox.com>)
Ответы Re: Error calling self-made plpgsql function "function XYZ(bigint)  (Markus Schaber <schabi@logix-tt.com>)
Список pgsql-sql
Jep... but  pgAdmin_III inserts dbl-quotes, if there is some
CamelCase... but from sql-console i can create objects w/ or w/o
dbl-quotes, but in result i always get lower-cased objects..

Seems, i should `recreate` my db in lowercase.. it will take some time :(

Thanks for advance.

PS: problem here is that, then i initialize row in PHP, i do  $row =
$dbio->object($res)...
and PHP variables/object_properties ar case-sensitive...

2006/1/20, Michael Glaesemann <grzm@myrealbox.com>:
>
> On Jan 20, 2006, at 1:45 , Leif B. Kristensen wrote:
>
> > That is usual behaviour for RDBMSes. They are case-insensitive if you
> > use ALL_CAPS or small_letters only.
>
> PostgreSQL is case-insensitive in the sense that it down-cases
> identifiers that are not double-quoted, e.g.,
>
> MYSUPERFIELD -> mysuperfield
> MySuperField -> mysuperfield
> mysuperfield -> mysuperfield
>
> "MYSUPERFIELD" -> MYSUPERFIELD
> "MySuperField" -> "MySuperField"
> "mysuperfield" -> mysuperfield
>
> Michael Glaesemann
> grzm myrealbox com
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: Error calling self-made plpgsql function "function XYZ(bigint)