[GENERAL] pgplsql and notifications

2006-02-19 Thread Kenéz Attila
Hi all, I would like to implement a function in plpgsql (or sql if it is possible) that can say me if I had some notification of some listened table. I mean something like this: create procedure do_i_have_notifications(text) returns boolean as ' ... ' language (plpg)sql; (or: create pro

[GENERAL] FATAL: The database system is in recovery mode

2003-08-14 Thread Kenéz Attila
Hi, I have got a problem with PostgreSQL 7.3.2 with cygwin under Windows 98. At our clients sometimes during normal work the database goes into recovery mode. I do not know what couses it, but it seems that this happens when one of the client applications freeze (or the client application freeze w

Re: [GENERAL] MemoryContextAlloc: invalid request size

2003-06-30 Thread Kenéz Attila
Sorry, it runs on Win98, Cygwin and the version is 7.2. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Kenéz Attila > Sent: Monday, June 30, 2003 2:49 PM > To: Psql_General (E-mail) > Subject: [GENERAL] MemoryContextAlloc: in

[GENERAL] MemoryContextAlloc: invalid request size

2003-06-30 Thread Kenéz Attila
Hi, I have this error message during (I think) a simple select. (I think only because the user is far from me and I cannot reproduce the error.) I found a mail like this in the archive at 2002 august but there was no really solution for this. Is there any? Can the vacuum or dump/restore be one? T