Zeoslib Portal

@EgonHugeist

So I checked, they can be read now. And their content is seen in dbmemo.
for Zeos7eh1524 on D2006, DXE2 32/64, LazarusWin1.1.0/fpc 2.7.1 32/64.

Michal

@EgonHugeist Michael, Even better: Line 283: 1034: Result := stAsciiStream; {aclitem[]} // M.A. was //28: Result := stAsciiStream; {aclitem[]} and and you can undo the lock '_aclitem' From line 225: else if (TypeName = 'int2vector') or (TypeName = 'oidvector') then Result := stAsciiStream else if (...

@EgonHugeist Michael, I see that for now only turning off the aclitem should be enough: line 228: else if (TypeName <> '') and (TypeName[1] = '_') and not (TypeName = '_aclitem') then // ARRAY TYPES M.A. no '_aclitem' Again from line 225: else if (TypeName = 'int2vector') or (TypeName = 'oidvector'...

@EgonHugeist Zeos7eh1515 compiles and runs on D2006, DXE2 32/64, LazarusWin1.1.0/fpc 2.7.1 32/64. But to not get AV for PostgreSQL array types in ZdbcPostgreSQLUtils.pas had to change from line 225 else if (TypeName = 'int2vector') or (TypeName = 'oidvector') {or (TypeName = '_aclitem') M.A.} then ...

@EgonHugeist Yes I've seen. Zeos7eh1499 compiles and runs on D2006, DXE2 32/64, LazarusWin1.1.0/fpc 2.7.1 32/64. Still considering the problem of nested and array types in Oracle and PostgreSQL, I mentioned earlier. Here, interestingly discussed a similar problem with Access 2007 format: http://www...

@EgonHugeist

Delphi does not understand SharedSuffix in rev 1481.
It should be added SharedSuffix = 'so';
~line 125 file ZCompatibility.pas

Michal

@EgonHugeist

Michael,
For now, I do not have finished the test environment (and I do not have too much time). For commiting to the svn I'll get back to you when I will be prepared.

Michal

@EgonHugeist

Michael,
A very good subject to test are the system objects (tables, views) created when you install the database server. Attempted to display their content in the DBGrid is in my opinion a very good test.

Michal

@EgonHugeist Michael, Zeos7eh1466 (compiles and runs) on D2006, DXE2 32/64, LazarusWin1.1.0/fpc 2.7.1 32/64. It was necessary to make the change to PostgreSQL ZDbcPostgreSqlResultSet.pas line 203: 24: ColumnInfo.Precision := 64; { regproc } // M.A. was 10 As for the problem with the type of pg_cata...

@EgonHugeist And now for PostgreSQL. This table does not open (produces AV): CREATE TABLE pg_catalog.pg_namespace ( nspname NAME NOT NULL, nspowner OID NOT NULL, nspacl pg_catalog.aclitem[] <------------------- ) WITH OIDS; ( Similar to pg_catalog.pg_class and pg_catalog.pg_database) Michal

@EgonHugeist Well, this is even more interesting in Oracle (than BFILE): http://psoug.org/reference/collections.html http://www.orafaq.com/wiki/NESTED_TABLE Here is an example table for the ZEOS reports an error when opening: CREATE TABLE SYSTEM.AQ$_QUEUES ( OID RAW(16), EVENTID NUMBER NOT NULL, &q...

@EgonHugeist

Zeos7eh1458 compiles and runs on D2006, DXE2 32/64, LazarusWin1.1.0/fpc 2.7.1 32/64.
With my hotfix also

Michal

You may want to download versions of Firebird-2.5.2.26510:
http://www.firebirdsql.org/en/snapshot-builds/
a lot of bugs version 2.1 removed.

Michal

@EgonHugeist

I can not play a situation in which I watched, but I remember the few times I had with this phenomenon (big slowdown) experience.
Recently I just do not use readonly.

Michal

@EgonHugeist I checked in LazarusWin1.1.0/fpc 2.7.1 32/64 SVN 26-5-2012 (Zeos7eh1439) After applying the hotfix to fpc SetData (@ R, False) can remove 1221: TimeStamp = DateTimeToTimeStamp (TDateTime (Buffer ^)); from Zeos7. (I wonder how people used to now datasets(other then Zeos7eh) and dbgrids ...