plpgsql functions crash cvs

[Kris Jurka <books(at)ejurka(dot)com>]

eKol in #postgresql reported a problem with a plpgsql function crashing 
the server.  I tested the attached against 8.2cvs as of this morning 
and got this stacktrace:

#0  plpgsql_xact_cb (event=XACT_EVENT_COMMIT, arg=0x0) at pl_exec.c:4521
#1  0x000000000046f43d in CallXactCallbacks (event=XACT_EVENT_COMMIT)
    at xact.c:2618
#2  0x000000000047138b in CommitTransaction () at xact.c:1534
#3  0x0000000000472be7 in CommitTransactionCommand () at xact.c:2184
#4  0x000000000058ecde in finish_xact_command () at postgres.c:2017
#5  0x0000000000590475 in exec_simple_query (
    query_string=0x8f8f28 "select admin.fn_revoke_all('public');")
    at postgres.c:1041
#6  0x00000000005917ab in PostgresMain (argc=4, argv=0x8bb360,
    username=0x8bb320 "jurka") at postgres.c:3231
#7  0x0000000000566a18 in ServerLoop () at postmaster.c:2917
#8  0x0000000000567861 in PostmasterMain (argc=3, argv=0x89b830)
    at postmaster.c:980
#9  0x00000000005250de in main (argc=3, argv=0x3e8) at main.c:254

Kris Jurka

Attachment: funcs.sql
Description: Text document