Search found 25 matches

by alexs75
15.02.2017, 12:19
Forum: PostgreSQL
Topic: Zeos and tsvector
Replies: 0
Views: 140

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: 479

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: 479

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: 479

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: 479

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: 479

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 Betatest Forum
Topic: work with PostgreSQL memleak on server after 3936
Replies: 3
Views: 182

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 Betatest Forum
Topic: error parse -- comment
Replies: 4
Views: 264

Re: error parse -- comment

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

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: 771

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: 771

Re: TZAbstractCachedResultSet.DisposeCachedUpdates

Fixed error when using TZReadOnlyQuery and TZConnection.Commit
by alexs75
02.12.2014, 12:37
Forum: ZeosLib 7.1 stable Forum
Topic: ZQuery ZUpdateSql
Replies: 9
Views: 836

Re: ZQuery ZUpdateSql

In the CachedUpdate = true, this test should only work when calling ApplyUpdate. Now it works after calling Post.
by alexs75
20.11.2014, 14:55
Forum: ZeosLib 7.1 stable Forum
Topic: ZQuery ZUpdateSql
Replies: 9
Views: 836

Re: ZQuery ZUpdateSql

Is it possible to disable this check, if Zquery.CashedUpdate = true?
by alexs75
11.11.2014, 06:40
Forum: ZeosLib 7.2 Betatest Forum
Topic: Error on compile ZOleDB.pas
Replies: 1
Views: 348

Error on compile ZOleDB.pas

Fedora 20 x64 Free Pascal Compiler version 2.7.1 [2014/09/15] for x86_64 Zeos 7.2 rev 3482 (1002) Target OS: Linux for x86-64 (3104) Compiling zplain.pas (3104) Compiling /usr/local/share/lazarus/components/zeos/src/plain/ZOleDB.pas /usr/local/share/lazarus/components/zeos/src/plain/ZOleDB.pas(2329,...

Go to advanced search