Search found 25 matches

by martinrame
14.03.2014, 13:53
Forum: PostgreSQL
Topic: Logging parameters
Replies: 1
Views: 514

Logging parameters

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...
by martinrame
28.02.2014, 15:32
Forum: PostgreSQL
Topic: [Solved] Strange metadata queries
Replies: 3
Views: 1403

Re: [Solved] Strange metadata queries

Thanks marsupilami, I was already using TZQuery.ReadOnly := True. After setting UseMetadata in TZConnection the messages where removed.
by martinrame
27.02.2014, 15:20
Forum: PostgreSQL
Topic: [Solved] Strange metadata queries
Replies: 3
Views: 1403

Re: Strange metadata queries

I've also found, by enabling logging on the server, that those queries are sent even without TZSqlmonitor enabled.
by martinrame
26.02.2014, 19:48
Forum: PostgreSQL
Topic: [Solved] Strange metadata queries
Replies: 3
Views: 1403

[Solved] Strange metadata queries

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...
by martinrame
26.02.2014, 19:43
Forum: PostgreSQL
Topic: [Solved] WARNING: nonstandard use of \\ in a string literal
Replies: 2
Views: 813

Re: WARNING: nonstandard use of \\ in a string literal

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

I'm using 7.0.3
by martinrame
25.02.2014, 15:16
Forum: PostgreSQL
Topic: [Solved] WARNING: nonstandard use of \\ in a string literal
Replies: 2
Views: 813

[Solved] WARNING: nonstandard use of \\ in a string literal

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 ...
by martinrame
03.12.2010, 18:31
Forum: 6.6 - stable
Topic: ZPlainPostgreSqlDriver bug?
Replies: 2
Views: 241

I downloaded ZEOSLIB_STABLE_REV840.zip and this seems to be fixed.
by martinrame
03.12.2010, 16:45
Forum: 6.6 - stable
Topic: ZPlainPostgreSqlDriver bug?
Replies: 2
Views: 241

ZPlainPostgreSqlDriver bug?

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 ...
by martinrame
07.01.2010, 13:46
Forum: PostgreSQL
Topic: Transaction Isolation Level
Replies: 5
Views: 1912

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 ...
by martinrame
30.12.2009, 15:55
Forum: PostgreSQL
Topic: Transaction Isolation Level
Replies: 5
Views: 1912

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?
by martinrame
29.12.2009, 21:19
Forum: PostgreSQL
Topic: Transaction Isolation Level
Replies: 5
Views: 1912

Transaction Isolation Level

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...
by martinrame
20.10.2009, 15:38
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 7 and Delphi 2010
Replies: 1
Views: 318

Delphi 7 and Delphi 2010

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.
by martinrame
10.07.2008, 14:44
Forum: PostgreSQL
Topic: BeginReq and ReadCommitted
Replies: 1
Views: 449

BeginReq and ReadCommitted

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....
by martinrame
20.06.2008, 21:02
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Firebird Metadata
Replies: 1
Views: 547

Sorry, my fault.

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

Leonardo
by martinrame
20.06.2008, 20:53
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Firebird Metadata
Replies: 1
Views: 547

Firebird Metadata

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...

Go to advanced search