| From: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Error in calling a function with protocol 7.4 |
| Date: | 2015-12-09 00:40:14 |
| Message-ID: | CAJrrPGcRFKQhwveE-hLcTnr94hO26GHXrO799h2-FCPDZCQ04A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
when function is called using the following way, it generates an error.
? = CALL procname ()
The error message with 09.03.0400 with protocol 7.4 is
-----------------------------------------------------
errstate -> 08P01
errcode -> 7
errmsg -> ERROR: invalid message format; Error while executing the query
-----------------------------------------------------
But it passes with protocol 6.4 in version 09.03.0400. The same test passes
with either protocol versions in version 09.03.0100.
Function:
CREATE OR REPLACE FUNCTION PROC1() RETURNS INTEGER
AS $$
BEGIN
RETURN 1234;
END;
$$ LANGUAGE 'plpgsql';
Here I attached the sample test file to reproduce the problem. I want to know
whether is it a problem or normal behavior in this version?
Regards,
Hari Babu
Fujitsu Australia
| Attachment | Content-Type | Size |
|---|---|---|
| test.c | text/x-csrc | 1.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Uffe Kousgaard | 2015-12-13 12:09:56 | Installing odbc-driver on client |
| Previous Message | Haribabu Kommi | 2015-12-02 07:40:48 | How to get actual number of rows affected with parameter array |