Re: Version 1 Calling convention

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: alvherre(at)commandprompt(dot)com, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Version 1 Calling convention
Date: 2006-08-30 04:30:28
Message-ID: a47902760608292130redde58ej94fbd6b5e8de05e6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Well I think I can because so far its been working fine.
Anyways, as suggested by others too, I'm going to change it to SPI but right
now the matter of concern is the error that I'm getting.
Is it because I'm using ECPG in server side code or something else?

On 8/30/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Bali 2006-08-30 04:53:57 Re: Version 1 Calling convention
Previous Message Alvaro Herrera 2006-08-30 04:28:15 Re: Version 1 Calling convention

Browse pgsql-novice by date

  From Date Subject
Next Message Jasbinder Bali 2006-08-30 04:53:57 Re: Version 1 Calling convention
Previous Message Alvaro Herrera 2006-08-30 04:28:15 Re: Version 1 Calling convention