Re: Function call crashes server

Does the same thing here.

Sounds like a serious problem to me too.

Greg

On Wed, 2002-03-20 at 20:46, Bruce Momjian wrote:
> If I do this as any user:
>
>     SELECT update_pg_pwd();
>
> it crashes all backends and causes a server-wide restart.  Is this
> acceptable behavior?  I am sure there are other cases too.  Isn't it a
> problem that we let ordinary users crash the server and cause a restart?
>
> ---------------------------------------------------------------------------
>
> LOG:  server process (pid 23337) was terminated by signal 11
> LOG:  terminating any other active server processes
> LOG:  all server processes terminated; reinitializing shared memory and semaphores
> FATAL:  The database system is starting up
> LOG:  database system was interrupted at 2002-03-21 03:42:08 CET
> LOG:  checkpoint record is at 0/43C048
> LOG:  redo record is at 0/43C048; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction id: 99; next oid: 24747
> LOG:  database system was not properly shut down; automatic recovery in progress
> LOG:  redo starts at 0/43C088
> LOG:  ReadRecord: record with zero length at 0/4421B4
> LOG:  redo done at 0/442190
> LOG:  database system is ready
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org