Skip site navigation (1) Skip section navigation (2)

Creating trigger function with argument(s) gets backend crash.

From: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Creating trigger function with argument(s) gets backend crash.
Date: 2005-07-06 08:59:24
Message-ID: 42CB9D6C.9020209@nttdata.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi all,

When I attempted to create a trigger function with argument(s),
the backend got crashed.

I know this operation is wrong, however I think the backend crash
mustn't be occured, it should be a syntax error or something like that.

Is this a bug, or just my mistake(or misunderstanding)?

Now I'm working on CVS tree retreived on 2005/07/01.

Thanks.
------------------------------------------------------------
snaga=# CREATE FUNCTION t1_trig_func(integer) RETURNS trigger
snaga-# AS '
snaga'# BEGIN
snaga'#   RAISE NOTICE ''foo'';
snaga'# END
snaga'# ' LANGUAGE 'plpgsql';
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!> \q
------------------------------------------------------------

-- 
NAGAYASU Satoshi <nagayasus(at)nttdata(dot)co(dot)jp>

Responses

pgsql-bugs by date

Next:From: Denis VlasenkoDate: 2005-07-06 11:35:28
Subject: BUG #1756: PQexec eats huge amounts of memory
Previous:From: Oliver JowettDate: 2005-07-06 03:09:39
Subject: Re: BUG #1753: Query Optimizer does not work well with libpg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group