Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-08 Thread Pavel Stehule
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. decibel=# select 'pg_catalog.abstimelt (abstime,abstim

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-06 Thread Jim Nasby
On Oct 6, 2006, at 1:47 AM, Pavel Stehule wrote: On Oct 5, 2006, at 9:30 AM, Pavel Stehule wrote: With func oid I can get all other info later, without it, I need estimate which functions are in stack track. Why do you need the OID to know exactly what function something is? What's wrong

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-06 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> 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

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-05 Thread Pavel Stehule
On Oct 5, 2006, at 9:30 AM, Pavel Stehule wrote: With func oid I can get all other info later, without it, I need estimate which functions are in stack track. Why do you need the OID to know exactly what function something is? What's wrong with schema.function(args)? -- oid is simply un

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-05 Thread Jim Nasby
On Oct 5, 2006, at 9:30 AM, Pavel Stehule wrote: With func oid I can get all other info later, without it, I need estimate which functions are in stack track. Why do you need the OID to know exactly what function something is? What's wrong with schema.function(args)? -- Jim Nasby

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-05 Thread Pavel Stehule
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > And what two variants of errcontext drived by GUC? First current > (compatible) and second enhanced (with oid, params, maybe all possible debug > values) and possible machine's readable. This enhanced variant can be > compatible and shared in all

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-05 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > And what two variants of errcontext drived by GUC? First current > (compatible) and second enhanced (with oid, params, maybe all possible debug > values) and possible machine's readable. This enhanced variant can be > compatible and shared in all env

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-05 Thread Pavel Stehule
Hi, Tom, Tom Lane wrote: >> I miss some info in context: function's oid, function's argumenst and >> schema. Maybe: > >> 199292 function public.foo(int, int, int) language plpgsql statement return >> line 10 > > Putting the OID there is a seriously awful idea, not least because it > would make

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-04 Thread Pavel Stehule
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > I miss some info in context: function's oid, function's argumenst and > schema. Maybe: > 199292 function public.foo(int, int, int) language plpgsql statement return > line 10 Putting the OID there is a seriously awful idea, not least because it wo

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from

2006-10-04 Thread Markus Schaber
Hi, Tom, Tom Lane wrote: >> I miss some info in context: function's oid, function's argumenst and >> schema. Maybe: > >> 199292 function public.foo(int, int, int) language plpgsql statement return >> line 10 > > Putting the OID there is a seriously awful idea, not least because it > would mak

Re: [HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-04 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > I miss some info in context: function's oid, function's argumenst and > schema. Maybe: > 199292 function public.foo(int, int, int) language plpgsql statement return > line 10 Putting the OID there is a seriously awful idea, not least because it woul

[HACKERS] PL/pgSQL Todo, better information in errcontext from plpgsql

2006-10-03 Thread Pavel Stehule
Hello, I miss some info in context: function's oid, function's argumenst and schema. Maybe: 199292 function public.foo(int, int, int) language plpgsql statement return line 10 or short version: 1229298 function public.foo 10 return which is easy parseable Best regards Pavel Steh