Re: [BUGS] BUG #5108: plpgsql function name conflict with table alias

2009-10-13 Thread Balazs Klein
l learned that I shouldn't do this anyway. Thanks and regards. Balazs On Tue, Oct 13, 2009 at 3:04 AM, Tom Lane wrote: > Balazs Klein writes: > > CREATE OR REPLACE FUNCTION instreq(OUT instreq_id integer) > > ... > > Select instreq.instreq_id From aaa instreq &g

Re: [BUGS] BUG #5108: plpgsql function name conflict with table alias

2009-10-12 Thread Balazs Klein
; BEGIN FOR rec IN Select instreq.instreq_id From aaa instreq LOOP instreq_id =rec.instreq_id; RETURN NEXT; End Loop; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100 ROWS 1000; On Mon, Oct 12, 2009 at 4:15 PM, Tom Lane wrote: > "Balazs Klein" writes: > > On 8.

[BUGS] BUG #5108: plpgsql function name conflict with table alias

2009-10-12 Thread Balazs Klein
The following bug has been logged online: Bug reference: 5108 Logged by: Balazs Klein Email address: balazs.kl...@gmail.com PostgreSQL version: 8.4.1 Operating system: Windows XP Description:plpgsql function name conflict with table alias Details: I have a plpgsql