GetSchemaNames fails

GetSchemaNames fails

Postby arkangles » Sun 24 May 2009 07:44

The GetSchemaNames method on TSQLConnection is actually returning a list of roles, not a list of schema names. I'm running Delphi 2009 and PostgreSQL 8.3. Is this a bug in the dbExpress driver?

Posts: 3
Joined: Sun 26 Apr 2009 12:02

Postby Plash » Fri 12 Jun 2009 08:55

This is not a bug in the driver.
This is a bug in the TSQLConnection component. Its GetSchemaNames method queries the list of user names from the driver metadata. This method works only with DBMS where user names are the same as schema names.
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Return to dbExpress driver for PostgreSQL