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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
