Thread: The SoundEx Contrib Example

The SoundEx Contrib Example

From
Thornton Prime
Date:
I am playing with the SoundEx example in the contrib section of
the postgresql distribution, using it as an example to learn
building my own functions ...

All seems to go well until I get to

CREATE OPERATOR #= (leftarg=text, rightarg=text,
procedure=text_sx_eq, commutator=text_sx_eq)\g

It reports back ...

NOTICE: buffer leak [49] detected in BufferPoolCheckLeak()
CREATE

Then when I try SELECT * FROM T WHERE F #= 'Hello, World'; it
drops the connection to the backend.

I can't see anything wrong in soundex.c. Any suggestions?

thornton