Page 1 of 1

Error on PostgreSQL, ZStoredProc and function with schema

Posted: 03.12.2019, 13:08
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.

Re: Error on PostgreSQL, ZStoredProc and function with schema

Posted: 03.12.2019, 13:28
by marsupilami
Hello,

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

Posted: 03.12.2019, 13:59
by alexs75
I forgot to write - all this on FPC + Lazarus.
Do you need a test app on Lazarus + PostgreSQL?

Re: Error on PostgreSQL, ZStoredProc and function with schema

Posted: 17.12.2019, 08:49
by alexs75
A similar error when adding / changing / displaying data from numerical fields defined using domains.

https://sourceforge.net/p/zeoslib/tickets/401/

Re: Error on PostgreSQL, ZStoredProc and function with schema

Posted: 19.12.2019, 15:24
by marsupilami
Hello,

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

Jan