[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

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

2009-10-12 Thread Tom Lane
Balazs Klein balazs.kl...@gmail.com writes: On 8.4.1 on windows XP running the function gives an error message (Undefined column: 7 ERROR: record rec has no field instreq_id) wich is strange because the underlying query does return that column. There's really no way to investigate that without

[BUGS] BUG #5109: Error installing edb_apachephp.bin

2009-10-12 Thread Federico
The following bug has been logged online: Bug reference: 5109 Logged by: Federico Email address: federicoaagui...@gmail.com PostgreSQL version: 8.4 Operating system: Open SuSE 11.1 64-Bit Description:Error installing edb_apachephp.bin Details: Hello, when i'm

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

2009-10-12 Thread Balazs Klein
Hi, the test case below runs fine for me if the function name is not instreq and returns an error if it is. Regards. Balazs CREATE TABLE aaa ( instreq_id integer ); INSERT INTO aaa (instreq_id) VALUES (223); INSERT INTO aaa (instreq_id) VALUES (224); INSERT INTO aaa (instreq_id) VALUES

[BUGS] Kerberos authentication, Active Directory, and PostgreSQL

2009-10-12 Thread Turner, Ian
Hello pgsql-bugs, While trying to connect our PostgreSQL database to our Kerberos realm, we encountered the obscure message Invalid message length. Tracking this down, we discovered that it was emitted by src/backend/libpq/pqcomm.c in response to a rather large Kerberos message. The root cause

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

2009-10-12 Thread Tom Lane
Balazs Klein balazs.kl...@gmail.com writes: CREATE OR REPLACE FUNCTION instreq(OUT instreq_id integer) ... Select instreq.instreq_id From aaa instreq The problem that you've got here is that instreq.instreq_id is in fact a qualified reference to the function's OUT parameter. We didn't support