[BUGS] BUG #5643: ecpg program doesn't process WHENEVER NOT DATA FOUND

2010-09-05 Thread Alexander Pyhalov
The following bug has been logged online: Bug reference: 5643 Logged by: Alexander Pyhalov Email address: a...@rsu.ru PostgreSQL version: 8.4.4 Operating system: FreeBSD 8.1 Description:ecpg program doesn't process WHENEVER NOT DATA FOUND Details: I have test progra

Re: [BUGS] BUG #5643: ecpg program doesn't process WHENEVER NOT DATA FOUND

2010-09-05 Thread Michael Meskes
On Sun, Sep 05, 2010 at 08:21:48AM +, Alexander Pyhalov wrote: > Bug reference: 5643 > Logged by: Alexander Pyhalov > Email address: a...@rsu.ru > PostgreSQL version: 8.4.4 > Operating system: FreeBSD 8.1 > Description:ecpg program doesn't process WHENEVER NOT DATA

[BUGS] BUG #5644: Selecting ROW() in variable with 9.0 not compatible with 8.4

2010-09-05 Thread Valentine Gogichashvili
The following bug has been logged online: Bug reference: 5644 Logged by: Valentine Gogichashvili Email address: val...@gmail.com PostgreSQL version: 9.0RC1 Operating system: linux Description:Selecting ROW() in variable with 9.0 not compatible with 8.4 Details: Afte

Re: [BUGS] BUG #5644: Selecting ROW() in variable with 9.0 not compatible with 8.4

2010-09-05 Thread Tom Lane
"Valentine Gogichashvili" writes: > After migration to 9.0RC1 some stored procedures, working ok in 8.4 does not > work in 9.0. > The problem is that SELECT ROW(a,b,c) INTO var does not work any longer in > 9.0. It didn't work in 8.4 either. I tried the attached and got some variant of ERROR:

Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS

2010-09-05 Thread Peter Eisentraut
On fre, 2010-09-03 at 13:53 -0400, Tom Lane wrote: > Alvaro Herrera writes: > > Excerpts from Fabien COELHO's message of vie sep 03 13:39:19 -0400 2010: > >> I tried to explained that I'm analyzing other people's schemas. I cannot > >> ask all other people on the planet to rewrite their schemas,