search

coldbox-modules / qb

Fluent Query Builder for CFML
https://qb.ortusbooks.com/
MIT License
40 stars 35 forks source link

PostgresGrammar schema issue with table_catalog #250

Closed mjclemente closed 1 year ago

mjclemente commented 1 year ago

On lines 376 and 390, the PostgresGrammar.cfc references table_catalog when checking the schema.

At least in my current Postgres install (v14), table_catalog refers to the database name, while table_schema refers to the schema:

image

Consequently, I am unable to use cfmigrations/commandbox-migrations - they keep being unable to determine if the cfmigrations table is installed.

(as a side note, their versions of qb are a bit behind).

Happy to provide more info as needed.

Thanks!

elpete commented 1 year ago

Fixed in v9.1.5