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

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