Re: PL/pgSQL Todo, better information in errcontext from plpgsql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL Todo, better information in errcontext from plpgsql
Date
Msg-id 20591.1160145603@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL Todo, better information in errcontext from plpgsql  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
List pgsql-hackers
"Pavel Stehule" <pavel.stehule@hotmail.com> writes:
>> Why do you need the OID to know exactly what function something is?  What's 
>> wrong with schema.function(args)?

> oid is simply unique. I can take source code, args and all without parsing. 
> It's only one difference. I unlike parsing.

That isn't an adequate reason for pushing an implementation detail into
the user's face.  IMHO no error message seen by ordinary users should
mention OIDs at all.  A thought experiment: what would you do with the
message if we were to reimplement the system to not use OIDs?

I'm willing to talk about putting a complete specification of the
function (with schema and arg types) into the context line, but you
haven't really made the case why that wouldn't be just clutter for most
people.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump exclusion switches and functions/types
Next
From: Andrew Dunstan
Date:
Subject: Re: pg_dump exclusion switches and functions/types