Postgresql compileColumnListing method does not consider table_schema

• Laravel Version: all
• PHP Version: all
• Database Driver & Version: pgsql

Description:

Same as #13862, but looks like it's not fixed.

In class Database\Schema\Grammars\PostgresGrammar the compileColumnListing does not consider the table_schema attribute (like in the compileTableExists method).

Steps To Reproduce:

Same as #13862.

[srmklive]

Can you list a detailed error stack for this?

There is no error stack. Only what #13862 describes :

When you have multiple schemas in your database if you have a 'foo' table in a schema with a 'bar' column and in the schema specified in your connection have a 'foo' table without a 'bar' column then Schema::hasColumn('foo', 'bar') will return true.
Because of the compileColumnListing function, which returns :

"select column_name from information_schema.columns where table_name = '$table'";

and not :

"select column_name from information_schema.columns where table_name = '$table'" and table_schema = '$schema'"  ;

The table_schema used in compileTableExists but not in compileColumnListing

[themsaid]

Feel free to propose a fix and open a PR.

[themsaid]

@KevinHivert make sure you submit to 5.5 since this would be a breaking change.

[hakuno]

@themsaid Why would it be breaking?
@KevinHivert Mate, will you make any PR for?

Ps.: I'd need it on 5.4 version 😛

[themsaid]

Because after the change the some checks that used to return true ill return false :)

[hakuno]

@themsaid So they won't tell any lie anymore heh

But I'm sure the 5.4 version still can get it 😇

I will probably open a PR in the next few days (First one on Laravel 💪).

@themsaid Thanks for the advice ;)
Sorry, @hakuno 5.5 it will be.