[BUGS] BUG #6549: Wrong $PATH setting after installation

2012-03-22 Thread jf . vanderwoude
The following bug has been logged on the website: Bug reference: 6549 Logged by: Jelle Frans van der Woude Email address: jf.vanderwo...@gmail.com PostgreSQL version: 9.1.2 Operating system: OS X Snow Leopard Description: I've installed pg from the www.kyngchaos.com s

[BUGS] BUG #6550: Querry failed while using throung php program.

2012-03-22 Thread mkkrish
The following bug has been logged on the website: Bug reference: 6550 Logged by: M K Krishnan Email address: mkkr...@hotmail.com PostgreSQL version: 9.0.4 Operating system: Windows 7 Description: 11Variety One Warning: pg_query(): Query failed: ERROR: syntax error at

[BUGS] BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

2012-03-22 Thread aburacze
The following bug has been logged on the website: Bug reference: 6551 Logged by: Adam Buraczewski Email address: abura...@gmail.com PostgreSQL version: 9.1.3 Operating system: Linux (Fedora 16) Description: Hi! I have just found strange behaviour of PL/pgSQL in case

Re: [BUGS] BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

2012-03-22 Thread Kevin Grittner
wrote: > x1 | x2 | x3 > ++ > | 1 | 1 To reduce the ambiguity about what value is coming from where, I slightly modified the script before testing it against a recent HEAD build: create table t (c integer); create function p(out x1 integer, out x2 integer, out x3 integer)

Re: [BUGS] BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

2012-03-22 Thread Tom Lane
abura...@gmail.com writes: > I have just found strange behaviour of PL/pgSQL in case of using OUT > parameters and GET DIAGNOSTICS var = ROW_COUNT (PostgreSQL 9.1.3). Here is a > self-contained example: Wow, that's been broken since the beginning, apparently. There's an entirely bogus test in exe

Re: [BUGS] BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

2012-03-22 Thread Adam Buraczewski
> Wow, that's been broken since the beginning, apparently.  There's an > entirely bogus test in exec_stmt_getdiag(): Thanks for quick fix! :) Best regards, -- Adam Buraczewski -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.post

Re: [BUGS] BUG #6550: Querry failed while using throung php program.

2012-03-22 Thread Marti Raudsepp
On Thu, Mar 22, 2012 at 08:00, wrote: > LINE 1: select * from variety_dir where crop_cd= and variety_cd=1 You're missing a value for the crop_cd= clause. This error is supposed to occur. > Query works from SQL Screen. When uses through php it fails. You probably executed a different query from

Re: [BUGS] BUG #6549: Wrong $PATH setting after installation

2012-03-22 Thread Josh Kupershmidt
On Wed, Mar 21, 2012 at 10:12 AM, wrote: > Operating system:   OS X Snow Leopard > I've installed pg from the www.kyngchaos.com site. If the problem was caused by that installer, you'll have to contact them to fix their package. FYI, the Postgres packages for OS X supported here can be found at