Search found 28 matches

by alexs75
17.12.2019, 08:49
Forum: ZeosLib 7.3/8.0 Forum
Topic: Error on PostgreSQL, ZStoredProc and function with schema
Replies: 4
Views: 296

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/
by alexs75
03.12.2019, 13:59
Forum: ZeosLib 7.3/8.0 Forum
Topic: Error on PostgreSQL, ZStoredProc and function with schema
Replies: 4
Views: 296

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?
by alexs75
03.12.2019, 13:08
Forum: ZeosLib 7.3/8.0 Forum
Topic: Error on PostgreSQL, ZStoredProc and function with schema
Replies: 4
Views: 296

Error on PostgreSQL, ZStoredProc and function with schema

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...
by alexs75
15.02.2017, 12:19
Forum: PostgreSQL
Topic: Zeos and tsvector
Replies: 0
Views: 2140

Zeos and tsvector

zeos does not understand the type of tsvector
Is it possible to display the data as a string? or in the form of BLOB?
by alexs75
28.10.2016, 07:16
Forum: PostgreSQL
Topic: How to work with transaction in PostgreSQL
Replies: 10
Views: 3188

Re: How to work with transaction in PostgreSQL

I see it as follows: For itReadCommited mode will be 2 situations: 1. Without starting average bank explicitly in the code of my program. Then nothing at all to do. All messages from PostgreSQL reach Developer unchanged. Releasing resources to do both in the version prior to 3936. 2. With a clear st...
by alexs75
27.10.2016, 07:24
Forum: PostgreSQL
Topic: How to work with transaction in PostgreSQL
Replies: 10
Views: 3188

Re: How to work with transaction in PostgreSQL

It is because of resource leaks in the latest versions ZEOS I raised the topic. it is necessary to relieve them. Unfortunately I'm not very big expert in the ZEOS - yet not entirely understood. And I do not get the money for this work :-) In my opinion, the release of unused STATMENT code necessary ...
by alexs75
26.10.2016, 07:14
Forum: PostgreSQL
Topic: How to work with transaction in PostgreSQL
Replies: 10
Views: 3188

Re: How to work with transaction in PostgreSQL

All examples work with ReadCommited shown only for a short time transactions. But for me the critical fact that I can not control people's behavior - they can run the application (and nachanaet transaction) for the whole day. At the same time a lot of people working (> 1000). And get a very long tra...
by alexs75
25.10.2016, 06:34
Forum: PostgreSQL
Topic: How to work with transaction in PostgreSQL
Replies: 10
Views: 3188

Re: How to work with transaction in PostgreSQL

It operates in the starting mode is not explicit transaction. In 99% of cases, do not have to explicitly start the transaction. Zeos not true works ReadCommited mode. He was forced to start the transaction and all the time it keeps open. It's good for FireBird. PostgreSQL does not require it. Now Ze...
by alexs75
24.10.2016, 10:55
Forum: PostgreSQL
Topic: How to work with transaction in PostgreSQL
Replies: 10
Views: 3188

How to work with transaction in PostgreSQL

How to configure TZConnection to work in the following modes: All reading start without explicit transaction on the server When you call a method in the code ZConnection.StartTransaction start a transaction on the server When ZConnection.Commit or ZConnection.Rollback respectively to complete or can...
by alexs75
24.10.2016, 10:44
Forum: ZeosLib 7.2 Forum
Topic: work with PostgreSQL memleak on server after 3936
Replies: 3
Views: 537

work with PostgreSQL memleak on server after 3936

if TransactIsolationLevel:=tiNone; mem leak on server in this code: procedure TZPostgreSQLConnection.StartTransactionSupport; .. if Assigned(FUnpreparableStmts) then begin for x := FUnpreparableStmts.Count - 1 downto 0 do begin SQL := 'DEALLOCATE "' + {$IFDEF UNICODE}UnicodeStringToASCII7{$ENDI...
by alexs75
10.02.2016, 12:54
Forum: ZeosLib 7.2 Forum
Topic: error parse -- comment
Replies: 4
Views: 723

Re: error parse -- comment

work ok.
by alexs75
04.02.2016, 11:57
Forum: ZeosLib 7.2 Forum
Topic: error parse -- comment
Replies: 4
Views: 723

error parse -- comment

Lazarus 1.7 r51494M FPC 3.1.1 x86_64-linux-gtk 2 >svn info Path: . URL: http://svn.code.sf.net/p/zeoslib/code-0/trunk Relative URL: ^/trunk Repository Root: http://svn.code.sf.net/p/zeoslib/code-0 Repository UUID: d681b350-854c-439c-a81d-c0ce20710203 Revision: 3806 Node Kind: directory Schedule: no...
by alexs75
06.01.2015, 11:19
Forum: ZeosLib 7.1 stable Forum
Topic: TZAbstractCachedResultSet.DisposeCachedUpdates
Replies: 8
Views: 1361

Re: TZAbstractCachedResultSet.DisposeCachedUpdates

UpdatesPending not in TReadOnlyQuery. Therefore, an error occurs when calling. I put the test before calling. Previously the test was after the call to UpdatesPending.
by alexs75
06.01.2015, 08:42
Forum: ZeosLib 7.1 stable Forum
Topic: TZAbstractCachedResultSet.DisposeCachedUpdates
Replies: 8
Views: 1361

Re: TZAbstractCachedResultSet.DisposeCachedUpdates

Fixed error when using TZReadOnlyQuery and TZConnection.Commit