lnedialkov · GitHub

Problem

Release 3.2.1 seems to introduce a regression in the following use case:

$I->haveInDatabase('schema.table', [
    'id' => 999,
    'id_one' => $id1,
    'id_two' => $id2
]);

The error is the following: [PDOException] SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "schema.table" does not exist
The PostgreSql#getPrimaryKey query is:

SELECT a.attname
FROM   pg_index i
JOIN   pg_attribute a ON a.attrelid = i.indrelid
                     AND a.attnum = ANY(i.indkey)
WHERE  i.indrelid = '"schema.table"'::regclass
AND    i.indisprimary

Solution

Removing the quotes that were introduced in #82 fixes the problem.
Perhaps there is another way to support upper case table names?

Read the original on github.com ↗