X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 58ACC8B9EFE
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 10 Feb 2005 17:31:26 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 82354-07
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 10 Feb 2005 17:31:18 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 8B91E8B9CF9
	for <pgsql-interfaces@postgresql.org>;
	Thu, 10 Feb 2005 17:31:17 +0000 (GMT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1AHVD4R027780;
	Thu, 10 Feb 2005 12:31:13 -0500 (EST)
To: Seamus Thomas Carroll <carrolls@cpsc.ucalgary.ca>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Help with adding C-Language Functions 
In-reply-to: <Pine.LNX.4.60.0502100114310.5503@frost> 
References: <Pine.LNX.4.60.0502091954340.5503@frost>
	<Pine.LNX.4.60.0502100114310.5503@frost>
Comments: In-reply-to Seamus Thomas Carroll <carrolls@cpsc.ucalgary.ca>
	message dated "Thu, 10 Feb 2005 01:17:14 -0700"
Date: Thu, 10 Feb 2005 12:31:13 -0500
Message-ID: <27779.1108056673@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200502/38
X-Sequence-Number: 5283

Seamus Thomas Carroll <carrolls@cpsc.ucalgary.ca> writes:
> I changed my file from BlackboardFunctions.c to all lowercase, 
> blackboardfunctions.c, and the database now finds the add_one function.

I'm betting that the actual sequence of events was more like this:

	CREATE FUNCTION f1(...) as '/home/.../BlackboardFunctions' ...;
	[ test f1, it works, cool ]
	[ add add_one to C source file, recompile ]
	CREATE FUNCTION add_one(...) as '/home/.../BlackboardFunctions' ...;
	[ fails ]
	[ rename file ]
	CREATE FUNCTION add_one(...) as '/home/.../blackboardfunctions' ...;
	[ works ]

The reason the second try didn't work is that an existing backend will
not re-load an already loaded .so file, unless you force it to with the
LOAD command.  It doesn't notice that you've modified the file.  Had you
started a fresh session, things would have worked, too.

			regards, tom lane