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

From: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: 2006-01-19 16:45:42
Message-ID: 200601191745.42918.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday 19 January 2006 14:06, Juris wrote:
>Argh... big thanks.. did not know what pgAdmin/PG have any
>case-sensitive issues with functions...
>
>Also for fields it is relative... without dbl-quotes i could not query
>anything (i am using "MySuperField"-like field names)

That is usual behaviour for RDBMSes. They are case-insensitive if you
use ALL_CAPS or small_letters only. But if you use CamelCasing (which
is the canonical name of this style), you're actually the one who
imposes a case-sensitiveness upon the DB interpreter. So, the advice
usually goes to avoid CamelCasing like the plague.

regards,
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-19 22:38:22 Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Previous Message T E Schmitz 2006-01-19 16:42:18 Re: indexing for left join