Issue with PgDac since v3 (v2 was OK)

[syagrius]

Hello,

I have an issue since PgDac v3.x (Tested with V3.1.4/D7/D2010/PosgreSQL8.x/Posgresql9.x).

I need to open schema.
But the name of the schema contains a dot.
Like "devart.001", "devart.002.100" for instance.

Everything was Ok with PgDac v2.
But since v3 I am in a lot of trouble.

- PgDac cannot initialize the search_path.
procedure TPgSQLConnection.SetCurrentSchema() now calls the new function QuoteSchemasIfNeed() that fails to convert devart.001.
QuoteSchemasIfNeed('devart.001') should return "devart.001".
But it returns devart (without quote and with .001 trimed).

- And some functions fails.
Please take a look at function TPgSQLMetaData.GetTables()
AddWhere(WhereClause, 'n.nspname', '"' + GetConnection.GetCachedSchema + '"') failed to build correct clause.
So GetTables returns empty list.

How to reproduce:
Drop a TPgConnection and Open a schema containing a dot.
Call GetTableNames().

I can post a sample project if you want.

Many Thanks,
Syagrius

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.