Re: Missing magic block

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.