A similar error when adding / changing / displaying data from numerical fields defined using domains.
https://sourceforge.net/p/zeoslib/tickets/401/
Search found 28 matches
- 17.12.2019, 08:49
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Error on PostgreSQL, ZStoredProc and function with schema
- Replies: 4
- Views: 316
- 03.12.2019, 13:59
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Error on PostgreSQL, ZStoredProc and function with schema
- Replies: 4
- Views: 316
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?
- 03.12.2019, 13:08
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Error on PostgreSQL, ZStoredProc and function with schema
- Replies: 4
- Views: 316
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...
- 15.02.2017, 12:19
- Forum: PostgreSQL
- Topic: Zeos and tsvector
- Replies: 0
- Views: 2170
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?
Is it possible to display the data as a string? or in the form of BLOB?
- 28.10.2016, 07:16
- Forum: PostgreSQL
- Topic: How to work with transaction in PostgreSQL
- Replies: 10
- Views: 3303
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...
- 27.10.2016, 07:24
- Forum: PostgreSQL
- Topic: How to work with transaction in PostgreSQL
- Replies: 10
- Views: 3303
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 ...
- 26.10.2016, 07:14
- Forum: PostgreSQL
- Topic: How to work with transaction in PostgreSQL
- Replies: 10
- Views: 3303
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...
- 25.10.2016, 06:34
- Forum: PostgreSQL
- Topic: How to work with transaction in PostgreSQL
- Replies: 10
- Views: 3303
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...
- 25.10.2016, 06:27
- Forum: ZeosLib 7.2 Forum
- Topic: work with PostgreSQL memleak on server after 3936
- Replies: 3
- Views: 559
Re: work with PostgreSQL memleak on server after 3936
Zeos not true works ReadCommited mode. See http://zeoslib.sourceforge.net/viewtopi ... 041#p77041
- 24.10.2016, 10:55
- Forum: PostgreSQL
- Topic: How to work with transaction in PostgreSQL
- Replies: 10
- Views: 3303
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...
- 24.10.2016, 10:44
- Forum: ZeosLib 7.2 Forum
- Topic: work with PostgreSQL memleak on server after 3936
- Replies: 3
- Views: 559
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...
- 10.02.2016, 12:54
- Forum: ZeosLib 7.2 Forum
- Topic: error parse -- comment
- Replies: 4
- Views: 744
Re: error parse -- comment
work ok.
- 04.02.2016, 11:57
- Forum: ZeosLib 7.2 Forum
- Topic: error parse -- comment
- Replies: 4
- Views: 744
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...
- 06.01.2015, 11:19
- Forum: ZeosLib 7.1 stable Forum
- Topic: TZAbstractCachedResultSet.DisposeCachedUpdates
- Replies: 8
- Views: 1397
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.
- 06.01.2015, 08:42
- Forum: ZeosLib 7.1 stable Forum
- Topic: TZAbstractCachedResultSet.DisposeCachedUpdates
- Replies: 8
- Views: 1397
Re: TZAbstractCachedResultSet.DisposeCachedUpdates
Fixed error when using TZReadOnlyQuery and TZConnection.Commit