On Sun, Apr 22, 2007 at 06:52:33PM -0400, Brad Buran wrote:
> I'm trying to learn how to write custom extensions to postgres so wrote a
> basic C function to see how it works. However, I keep getting the following
> error "Missing magic block" when I try to add the function to the database.
> According to the documentation in the manual, all I need to do is add the
> following:
<snip>
> And the sql statement I am using is:
>
> CREATE FUNCTION add_one(IN int)
> RETURNS int
> AS 'add_one'
> LANGUAGE C;
Shouldn't the name of the library appear in there somewhere?
Also, you may need to exit and restart psql to get a new session to
make sure the new version of the library is loaded.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.