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

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

2006-10-06 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

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 an

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-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 it

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

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 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-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 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 would