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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Creating trigger function with argument(s) gets backend crash.
Date: 2005-07-06 14:48:51
Message-ID: 200507061448.j66Empc18329@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Satoshi Nagayasu wrote:
> 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

Yea, funny things is I saw the same crash last week when playing with
something, and I assumed creating a function shouldn't make it crash,
but I wasn't sure, so I didn't report it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-07-06 14:49:31
Subject: Re: Creating trigger function with argument(s) gets backend crash.
Previous:From: Harald Armin MassaDate: 2005-07-06 13:52:30
Subject: Re: BUG #1756: PQexec eats huge amounts of memory

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