Re: plpgsql won't work

Please keep replies on list...

All I can suggest is to try running the regression tests to check your
installation. It sounds like the problem lies there somewhere...

Regards, Dave.

> -----Original Message-----
> From: Infodine [mailto:infodine(at)infodine(dot)com]
> Sent: 29 April 2002 22:59
> To: Dave Page
> Subject: RE: [CYGWIN] plpgsql won't work
>
>
> Hi,
>
> I tried it on the server and the same thing happens. I call
> the function and I hear the scsi drives pound for about 5-6
> seconds then I get the error and it closes the connection not
> returning any result.
>
> So does the plpgsql.dll file process the function? I can't
> figure out why it isn't working. The handler points to the
> file so it shouldn't matter where it is. In the cygwin shell
> it is located in /usr/lib/plpgsql.dll
>
> why would it pound the drives?... it is a simple function for
> sales tax and it should return a value....
>
> Hmm, I see the handler function is set up as a "C" Language
> function. I then look at the language C and it has no handler
> but says in the comments that /bin/cc ..... cc is the C
> compiler? If my cygwin doesn't have cc then no functions
> relying on C will work... correct?
>
> Warren
>
>
>
>
> At 08:10 PM 4/29/2002 +0100, you wrote:
>
>
> > > -----Original Message-----
> > > From: Infodine [mailto:infodine(at)infodine(dot)com]
> > > Sent: 29 April 2002 19:30
> > > To: pgsql-cygwin(at)postgresql(dot)org
> > > Subject: [CYGWIN] plpgsql won't work
> > >
> > >
> > > Hi,
> > >
> > > Using PGAdminII I created the plpgsql_call_handler
> function pointing
> > > it to the plpgsql.dll file.
> > >
> > > Then I created the language pointing it to the handler,
> clicked off
> > > trusted.
> > >
> > > I then created a very simple procedure:
> > >
> > > -- Function: sales_tax(float4)
> > > CREATE FUNCTION "sales_tax"("float4") RETURNS "float4" AS
> ' DECLARE
> > > subtotal ALIAS FOR $1; BEGIN return subtotal * 0.06; END;
> ' LANGUAGE
> > > 'plpgsql';
> > >
> > > Then I called it using an sql window:
> > >
> > > select sales_tax(45);
> > >
> > > When I execute the statement the main window says
> executing query, a
> > > few seconds go by and then it says executing query...Done. and I
> > > get this error:
> > >
> > > An error has occured in pgAdmin
> > > II:frmSQLInput.cmdExecute_Click: Number : -2147467259
> > > Description: Error while executing query;
> > > No response from backend;
> > > Error while reading from the socket
> > >
> > > Any ideas? I execute a plain 'sql' function and it runs fine.
> > > plpgsql won't run.
> > >
> > > Any help would be appreciated, I don't know if it is a windows
> > > problem so I posted here first.
> >
> >It works OK here on Cygwin/Win XP Pro with pgAdmin II 1.3.38. What
> >happens if you run it from psql?
> >
> >Regards, Dave.
>