Re: [GENERAL] Version 1 Calling convention

[Jasbinder Bali]

Do i need to download spi.h from somewhere or what? I can't see it anywhere

On 8/30/06, Jasbinder Bali <[EMAIL PROTECTED] > wrote:

OK. I've removed the ECPG code and error has gone away.
Thanks
jas

On 8/30/06, Alvaro Herrera < [EMAIL PROTECTED] > wrote:

Jasbinder Bali wrote:
> I have a .pgc file and i have the following code snippet in it:
>
> PG_FUNCTION_INFO_V1 (test);
>
> Datum
> test (PG_FUNCTION_ARGS)
> {
>  EXEC SQL BEGIN DECLARE SECTION;

You can't use ecpg in server-side functions.  You need to use the SPI
interface.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support