Lists: | pgsql-cygwin |
---|
From: | Infodine <infodine(at)infodine(dot)com> |
---|---|
To: | <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | plpgsql won't work |
Date: | 2002-04-29 18:29:54 |
Message-ID: | 5.0.0.25.2.20020429122025.0188acd0@mail.infodine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-cygwin |
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.
Thanks,
Warren
From: | Jason Tishler <jason(at)tishler(dot)net> |
---|---|
To: | Infodine <infodine(at)infodine(dot)com> |
Cc: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: plpgsql won't work |
Date: | 2002-04-29 19:19:57 |
Message-ID: | 20020429191957.GJ1152@tishler.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-cygwin |
Warren,
On Mon, Apr 29, 2002 at 12:29:54PM -0600, Infodine wrote:
> Any ideas?
Unfortunately no. All that I can offer is that the plpgsql regression
test passes. Sorry, but I have never used plpgsql under Cygwin or any
other platform for that matter.
Jason