[GENERAL] Backend is closed on a query execution - why?

Hi everybody! Is this a bug?: When I'm executing this (see below) query I have unexpected backend closing. When I will remove last line with "AND user_database.status_id = 'A'" - - it's working OK. But there are not a lot of conditions! Do anybody know about this problem? If

[GENERAL] Backend is closed on a query execution - why?

Hi everybody! Is this a bug?: When I'm executing this (see below) query I have unexpected backend closing. When I will remove last line with "AND user_database.status_id = 'A'" - - it's working OK. But there are not a lot of conditions! Do anybody know about this problem? If

[GENERAL] NULL value in one argument will clear all arguments in server-side functions ( plpgsql ) to NULL?!

Hi All, I'm using Postgres for the first time and have this problem: when I use NULL as the value of one of the parameters in my stored procedure, all the values of all the parameters in body of procedure will cleared to NULL too. (I have Postgres 7.0.2 on Linux RedHat 6.2 ) The simple example: