search

hoyvoy / laravel-cross-database-subqueries

Eloquent cross database compatibility in subqueries
MIT License
103 stars 45 forks source link

Postgres cross-database references #7

Open Juddling opened 5 years ago

Juddling commented 5 years ago

Description:

I'm trying to run a whereHas where one model lives in one database, and the pivot and the other model lives in another database.

Although your package correctly detects the connections are different, and alters the query, I believe Postgres itself doesn't support this behaviour:

SQLSTATE[0A000]: Feature not supported: 7 ERROR:  cross-database references are not implemented
maguilar92 commented 5 years ago

This two database are in different server or have another credentials?

Juddling commented 5 years ago

This two database are in different server or have another credentials?

Same server, same user in fact.