Zeoslib Portal

Hello, The sql form pgsl 8.2.5 for retieving "Access Privileges" raise exception EAccessViolation: sq := 'SELECT n.nspname as "Schema",' + 'c.relname as "Name",' + 'CASE c.relkind WHEN ''r'' THEN ''table'' ' + 'WHEN ''v'' THEN ''view'' ' + 'WHEN ''S'' THEN ''sequence'' ...

How to send '::' via string to Postgresql?
Example: 'SELECT myfield_timestamp::date;' this is work fine in psql, but is rejected via ZQuery.

Thanks

Paulonki

Mark

Excuse me but I am leaving vacation and I am very busy and without time to make the tests.
It seems that the ZSQLMetadata component is functioning well with new archive.
I promise to test more when to come back.

Happy 2007!!!

With best regards

Paulonki

Hello, They forgive me for the delay in answering. I am getting the Zeos in the address svn: /firmos.at/zeos/trunk. The source of GetTableNames is: procedure TZConnection.GetTableNames(const Pattern: string; List: TStrings); var Metadata: IZDatabaseMetadata; ResultSet: IZResultSet; begin CheckConnec...

It forgives not informed my platform: Delphi 2006 with Postgresql.
How much the GetTableNames() functions, I downloaded yesterday (22/12/2006) from SVN but not yet it is functioning.
Using to advantage the chance, desire to all a Happy Christmas.

Regards

Paulo

This for notice following bugs: 1) Function PingServer no has result value; This crashes application when TZConnection.Disconnect: function TZAbstractConnection.PingServer: Integer; begin RaiseUnsupportedException; end; 2) TZConnection.GetTableNames() allways return empty TString. Regards, Paulo

Thanks

Problem solved.


Paulo

Hello,

An 'Range Check Error' is occurring in the Zeos when retrieving fields of the type text or bytea in ZPlainPostgresqlDriver - function DecodeBYTEA().
My envinronment is Delphi2005 and Postgresql 8.1.4.
Please, i need help or solution.

Regards,

Paulo