Error on PostgreSQL, ZStoredProc and function with schema

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
alexs75
Junior Boarder
Junior Boarder
Posts: 28
Joined: 04.03.2014, 12:37

Error on PostgreSQL, ZStoredProc and function with schema

Post by alexs75 »

I'm try to migrate my project from zeos rev.3936 to current version

Zeos show error on open ZStoredProc1.Open;
If the function is in the public schema, then everything works.
If the function is in any other schema, I specify the schema name in the function name - for example, test21.sp_test
I get an error.

ZQuery with a similar query works fine

select
*
from
test21.sp_test (1, 3)

Tested on revision 6172 and 6150 - error present.
Old version of zeos work normal.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1935
Joined: 17.01.2011, 14:17

Re: Error on PostgreSQL, ZStoredProc and function with schema

Post by marsupilami »

Hello,

I created a ticket on this in our bugtracker on SourceForge: https://sourceforge.net/p/zeoslib/tickets/398/.
Best regards,

Jan
alexs75
Junior Boarder
Junior Boarder
Posts: 28
Joined: 04.03.2014, 12:37

Re: Error on PostgreSQL, ZStoredProc and function with schema

Post by alexs75 »

I forgot to write - all this on FPC + Lazarus.
Do you need a test app on Lazarus + PostgreSQL?
alexs75
Junior Boarder
Junior Boarder
Posts: 28
Joined: 04.03.2014, 12:37

Re: Error on PostgreSQL, ZStoredProc and function with schema

Post by alexs75 »

A similar error when adding / changing / displaying data from numerical fields defined using domains.

https://sourceforge.net/p/zeoslib/tickets/401/
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1935
Joined: 17.01.2011, 14:17

Re: Error on PostgreSQL, ZStoredProc and function with schema

Post by marsupilami »

Hello,

I see that you got in contact with EgonHugeist on the bug tracker. Good :)
Best regards,

Jan
Post Reply