Zeoslib Portal

Hi, I'm using Zeos 7.0.3 Stable and TZSqlMonitor, and found update queries with parameters are logged twice, first using "$N" (where N is the param number) then using "?", for example: 2014-03-14 09:48:36:430 cat: Prepare, proto: postgresql-8, msg: PREPARE 'update paciente set Id...

Thanks marsupilami, I was already using TZQuery.ReadOnly := True. After setting UseMetadata in TZConnection the messages where removed.

I've also found, by enabling logging on the server, that those queries are sent even without TZSqlmonitor enabled.

Hi, I've added a TZSqlMonitor (which is awesome) to my program, for optimization purpouses, and found there are many metadata queries made by Zeos, between my own queries. Is there a way to turn off those?. Those queries are similar to this: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnu...

Solved by setting TZQuery's Options := [doPreferPrepared];

I'm using 7.0.3

Hi, I'm storing bytea fields in a PostgreSql 8.4 database. When enabling log_collector, I see a lot of this: 2014-02-25 09:53:57 ART WARNING: nonstandard use of \\ in a string literal at character 42 2014-02-25 09:53:57 ART HINT: Use the escape string syntax for backslashes, e.g., E'\\'. 2014-02-25 ...

I downloaded ZEOSLIB_STABLE_REV840.zip and this seems to be fixed.

Hi, I updated my Zeos to 6.6.6-stable and found an exception that didn't appear in previous versions. To reproduce it you have to create a program following the next steps: 1) Connect to a PG-8.x database and do some queries. 2) Disconnect the network cable on the client machine. 3) Try to do a new ...

Thanks Wild_Pointer, yes, I written in a mixed Delphi/Sql! The solution was: At connection: TransactionIsolationLevel := tiNone; At StartTransaction: TransactionIsolationLevel := tiReadCommited; At Commit: Commit; TransactionIsolationLevel := tiNone; At Rollback: RollBack; TransactionIsolationLevel ...

So according to your suggestion, every time I need to start a transaction I should do this?:

BEGIN
SET TRANSACTION ISOLATION LEVEL := tiReadCommitted;

then
COMMIT or ROLLBACK

and
SET TRANSACTION ISOLATION LEVEL := tiNone again?

Hi, this morning I needed to do a couple of DDL commands in a PostgresSql 8.3 database, and the database took forever to execute the commands. The problem turned out to be that the table involved had many locks. When my app connects to the database, it has an explicitly set TransactionIsolationLevel...

Does Zeos 7 works in both Delphi 7 and 2010 (and Lazarus)?

P.S. sorry for being soo lazy to test it on my own.

Leonardo.

Hi, I connect my application to a PostgreSql 8.3 server with BeginReq=True (default) and TransactionIsolationLevel=tiReadCommitted. Everything works ok but when I check the server status using pgAdmin, my connection is in <Idle in transaction> state, that's because the method TZPostgreSQLConnection....

Sorry, my fault.

I was using AMetadata.TableName instead of AMetadata.FieldByName('TABLE_NAME').AsString;

Leonardo

I'm trying to extract the list of tables from an Firebird 2.0.3 database using TZSqlMetadata and this code: AConnection is a reference to the connected database (it's connected, don't worry!). AMetadata := TZSQLMetadata.Create(nil); AMetadata.Connection := AConnection; AMetadata.MetadataType := mdTa...