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.
Error on PostgreSQL, ZStoredProc and function with schema
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Error on PostgreSQL, ZStoredProc and function with schema
Hello,
I created a ticket on this in our bugtracker on SourceForge: https://sourceforge.net/p/zeoslib/tickets/398/.
Best regards,
Jan
I created a ticket on this in our bugtracker on SourceForge: https://sourceforge.net/p/zeoslib/tickets/398/.
Best regards,
Jan
Re: Error on PostgreSQL, ZStoredProc and function with schema
I forgot to write - all this on FPC + Lazarus.
Do you need a test app on Lazarus + PostgreSQL?
Do you need a test app on Lazarus + PostgreSQL?
Re: Error on PostgreSQL, ZStoredProc and function with schema
A similar error when adding / changing / displaying data from numerical fields defined using domains.
https://sourceforge.net/p/zeoslib/tickets/401/
https://sourceforge.net/p/zeoslib/tickets/401/
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Error on PostgreSQL, ZStoredProc and function with schema
Hello,
I see that you got in contact with EgonHugeist on the bug tracker. Good
Best regards,
Jan
I see that you got in contact with EgonHugeist on the bug tracker. Good
Best regards,
Jan