I have the folowing table structure:
Schema "public": with one table called "users"
Schema "forums": with one table called "users"
methods like PostgreSqlPlatform::getListTableForeignKeysSQL($table, $database = '') should list FK inside $table
the default search path is "public,pg_catalog"
calling PostgreSqlPlatform::getListTableForeignKeysSQL('users') it shuld extract the FK from public.users table, but this is the current result:
[PDOException] SQLSTATE: Cardinality violation: 7 ERROR: more than one row returned by a subquery used as an expression
this exception is thrown because PostgreSqlPlatform::getTableWhereClause do not cosider the current search path.
i propose the following implementation for PostgreSqlPlatform::getTableWhereClause
this implementation will restrict the search range only to current "search_path".
(sorry for my english)